Klipfolio Expert Certification

Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change it to ARRAY(“Apple”,”Apple”)?

May 31, 2020 Certificate Land

SUBSTITUTE
SUBSTITUTE_REGEX
REPLACE OR SUBSTITUTE
REPLACE
All of the above

The correct answer is:

REPLACE.

🎓 Get all the latest and 100% correct Klipfolio Expert Certification Exam Answers

← In which of the following scenarios is the DATE_ADD function the optimal date function to use? Select ALL that apply.
Which of the following “units” of time can be included in the DATE_STARTOF function? Select ALL that apply. →