Certification Answers

We help you to pass your exams

EN FR ES DE IT PT RU PL NL TR JA

CertificationAnswers

Which of the following is a way for an advertiser to monetize their app?

By

Which of the following is a way for an advertiser to monetize their app?

 

  • A) Charging for app downloads from the Apple iTunes or Google Play store

 

  • B) All of the listed answers are correct

 

  • C) In-app purchases

 

  • D) In-app ads

 

Explanation:

 

Paid downloads, in-app ads and in-app purchases are three main ways to monetize an app.

 

Adam has an Excel datasource set up in his Klipfolio account. Column 1 of the datasource contains the names of new customers in the past month and Adam suspects that the entries of this column have leading and trailing blanks. What is the function Adam should use to confirm this?

By

 

Adam has an Excel datasource set up in his Klipfolio account. Column 1 of the datasource contains the names of new customers in the past month and Adam suspects that the entries of this column have leading and trailing blanks. What is the function Adam should use to confirm this?

 

  • A) CONCAT  

 

  • B) SUBSTITUTE  

 

  • C) URLENCODE

 

  • C) URLDECODE

 

Match the Klipfolio Date and Time Functions below with the common use case where you would use them.

By

 

Match the Klipfolio Date and Time Functions below with the common use case where you would use them.

 

  • DATE​— = — Used to convert a human readable date string (2015/01/01), into a computer readable date string known as Epoch or Unix time. Correct
  • DATEVALUE​— = — Used to convert an Epoch or Unix date/time (computer readable date string) into a human readable date string (2015/01/01). Correct
  • DATE_IN​— = — Used to find dates that fall within a given time period, like day, week, month, quarter, year. Correct
  • DATE_ADD​— = — Used to add or subtract a certain number of units (seconds, minutes, days, etc.) to a given date in order to arrive at a different date. Correct
  • DATE_CONVERT​— = — Used to change the format of one human readable date string (2015/01/01) to another human readable date string (Jan 1, 2015), often for the purposes of sorting. Correct
  • DATE_STARTOF — = — Returns the first date of a given date period, like week, month, quarter, year.

 

Consider the following array of data: ARRAY(“Apple”,”Orange”,”EggPlant”,”Apple”,”Zucchini”,”Carrot”,”Orange”,”EggPlant”,”Kale”,”Bananas”). What function would you use to replace “EggPlant” with “Brinjal” AND “Kale” with “SomeGreenThing”?

By

Consider the following array of data: ARRAY(“Apple”,”Orange”,”EggPlant”,”Apple”,”Zucchini”,”Carrot”,”Orange”,”EggPlant”,”Kale”,”Bananas”). What function would you use to replace “EggPlant” with “Brinjal” AND “Kale” with “SomeGreenThing”?

 

  • A) REPLACE

 

  • B) SUBSTITUTE

 

  • C) SUBSTITUTE_REGEX

 

  • D) REPLACE OR SUBSTITUTE

 

  • E) All of the above

 

Consider the following scenario: You’re the owner of a paint shop and you’re making a Klip that has a table showing the number of one-gallon paint cans customers have purchased. You want to show the 10 customers that purchased the most of amount of paint cans. If you use the “Top” filter action on the column showing the number of paint cans, you need to apply the sort action first.

By

 

Consider the following scenario: You’re the owner of a paint shop and you’re making a Klip that has a table showing the number of one-gallon paint cans customers have purchased. You want to show the 10 customers that purchased the most of amount of paint cans. If you use the “Top” filter action on the column showing the number of paint cans, you need to apply the sort action first.

 

  • A) True

 

  • B) False