CertificationAnswers

Consider the following: You have a JSON datasource and you wish to select a node which has a number as a name. You can accomplish this by either using * in place of the number in the xpath to get all the contents of the node or using /*[name(.)=’number’] in place of the number in the xpath to get the data under a specific node.

• A) True

• B) False

Consider the following scenario. You’re building a table component showing dates in the current month in column 1 and corresponding sessions for each day in column 2 (from web traffic data from Google Analytics). In your Google Analytics datasource, you also have the channel grouping for your sessions (per day) and you wish to only show data coming from organic sources. However, you do not wish to have a visible column in your table that shows the channel grouping. How would you use filter actions to show only dates and sessions corresponding to organic traffic in your table? Select the best practice option.

• A) Add hidden data which will contain channel grouping column from your Google Analytics datasource, use filter action to include “organic” option

• B) Use SELECT function in each column to filter data based on the logic that the channel grouping column’s “organic” entries must be filtered

• C) Put a column in your table which will contain channel grouping column from Google Analytics datasource, use filter action to include “organic” option and set the visibility option of the column to hidden

• D) None of the above

Jieyi is building a bar/line chart showing the amount of new customers acquired by date and is using the DATERANGE( ) function to generate the X-axis between the start of the year and today. However, her datasource contains gaps for some dates. What is the function that Jieyi should use to align the data with gaps to the X-axis?

• A) LOOKUP

• B) kf:fill_elements

• C) IF

• D) ARRAY

• E) GROUPBY

You wish to convert 20171201 to December 01, 2017 using the DATE_CONVERT function as follows. Fill in the blank by selecting one of the following options: DATE_CONVERT( “20171201”, “yyyyMMdd”, _____).

• A) MMM/dd, yyyy

• B) MMMM dd, yyyy

• C) MMM dd, yyyy

• D) MM/dd/yy

• E) None of the above

How can you get rid of column headers from a visualization?

• A) Use the SLICE() function to remove the first row

• B) Create a filter, select the column header value, and exclude

• C) Select the cells in the datasource excluding the header

• D) A and B

• E) None of the above