CertificationAnswers

 

Given the following datasource of reservations,

…we want to create a table with column A being the name, and column B being the number of tables. However, sometimes the name is missing for the reservation, and we need to make sure that column A is not misaligned to column B. What formula would we use to do this?

 

• @/reservations/name

 

• SELECT ( @/reservations/name, @/reservations/name !=BLANK() )

 

• IF ( @/reservations/name !=BLANK(), @/reservations/name, BLANK() )

 

• @kf:fill_elements(/reservations, ‘name’)

 

 

 

In the data source shown below (which is a JSON data source), is “inferredCountry” a ​following-sibling​, or a ​preceding-sibling​to “timestampCustomer”?

 

• following-sibling

 

• preceding-sibling

 

 

Using the image below, select all scenarios where the variable “tm_country” is properly used in Klipfolio. Select ALL that apply.

 

• Option A

 

• Option B

 

• Option C

 

• Option D

 

For the following label component:

What would formulas X and Y give you?

X: !Label

Y: &Label

 

• X gives “Oct 16, 1989”? and Y gives “1989-10-16”?

 

• X gives “1989-10-16”? and Y gives “16/10/1989”?

 

• X gives”16/10/1989″? and Y gives “1989-10-16”?

 

• X gives “1989-10-16”? and Y gives “624499200”?

 

 

True or False? A User can be assigned to more than one role.

 

• True

 

• False

 

 

Which of the following is true of the LOOKUP function?

 

• It is similar to vLOOKUP in Excel

 

• Duplicate values in the 2nd parameter (“keys”) are not a problem.

 

• The 1st and 2nd paramters need to evaluate to the same number of values

 

• The 2nd and 3rd parameters need to evaluate to the same number of records

 

• Formulas that use LOOKUP cannot be sorted

 

• LOOKUP looks into a long list of values (input); finds a match in a second list of values (keys), and, where there is a match, returns a corresponding value (values).

 

• LOOKUP looks into data with duplicate values (input); deduplicates the input records (keys), and returns a summarized value based on the deduplicated data.