CertificationAnswers

How do you define a variable in a dynamic data source?

 

• A) “variable_name”

 

• B) $variable_name

 

• C) &variable_name

 

• D) {props.variable_name}

 

 

You’ve written MAPFLAT function as follows to paginate 10 pages of a dynamic datasource: MAPFLAT( CUMULATIVE(REPEAT(1,10)), “api_page_no”, @A:A). The api query that returns @A:A correpsonds to https://somebaseurl.com/endpoint?parameter1=value1&parameter2=value2&page={props.api_page_no}. From this api’s documentation, you find out that page number in the query must be of the format “page=1” NOT “page=1.0”. What function is missing within your formula to ensure it executes the pagination correctly?

 

• A) ARRAY

 

• B) MAP

 

• C) NUMBERFORMAT

 

• D) INDEXOF

 

• E) All of the above

 

• F) None of the above

 

 

You have a table Klip set up and want to remove the header row of your data. You can do this by using the “Exclude” feature of the filter action on one column and SLICE function in the other column.

 

• A) True

 

• B) False

 

What is the result of the following formula? DATEVALUE( DATE_STARTOF( DATE_ADD( DATE(“2017-11-15″,”yyyy-MM-dd”), year, “-1”), quarter), “yyyyMMdd”)

 

• A) 20161115

 

• B) 2017-10-01

 

• C) 2017-01-01

 

• D) 20161001

 

How do you define a variable in a formula?

 

• A) “variable_name”

 

• B) $variable_name

 

• C) &variable_name

 

• D) {props.variable_name}

 

 

True or False? Once a variable is saved it becomes available to everyone in the Klipfolio Account?

 

• A) True

 

• B) False