Klipfolio Expert Quiz: Kllipfolio Expert Certification Exam Answers 2022

Klipfolio Expert Certification Quiz Answers 2022

Please bear in mind that the Klipfolio Expert Certification Exam Question bank is much larger than the Klipfolio Expert Quiz Answers. There are a total of 180 questions and answers that might be asked. This means that every time you take the test, you will be presented with a list of randomly selected questions from the question bank.

Kllipfolio Expert Certification Exam Answers 2022

1. Given the following data source of reservations, …we want to create a table with column A being the name, and column B is 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?

A) @/reservations/name
B) SELECT ( @/reservations/name, @/reservations/name !=BLANK() )
C) IF ( @/reservations/name !=BLANK(), @/reservations/name, BLANK() )
D) @kf:fill_elements(/reservations, ‘name’)

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

A) following-sibling
B) preceding-sibling

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

A) Option A
B) Option B
C) Option C
D) Option D

4. Take a look at the Data Source and Klip Below. In order to build the “Delayed Units” Series, why is it necessary to use the LOOKUP function?

A) Because certain States have higher numbers of Units
B) Because each State has a different numbers of Cities
C) Because not all States have “Delayed” orders
D) Because there are four different Regions, and each Region has a different number of States.
E) Because the “Units” column has numerical data.

5. For the following label component: What would formulas X and Y give you? 
X: !Label

Y: &Label

A) X gives “Oct 16, 1989” and Y gives “1989-10-16”
B) X gives “1989-10-16” and Y gives “16/10/1989”
C) X gives“16/10/1989” and Y gives “1989-10-16”
D) X gives “1989-10-16” and Y gives “624499200”

6. In which of the following scenarios is DATE_STARTOF the optimal date function to use? Select ALL that apply.

A) To find values in the last 30 days
B) To find values in the current day
C) To find values between two randomly selected dates
D) To find values from “last week”
E) To find values between the start of last month, and another given date

7. Consider the following screen grab. The output format of the date pickers are set to Unix format. How can you use the filter actions to filter the bar/line chart?

A) Put a hidden data to the bar/line chart which contains the dates in unix format, check that format type is set to number and place filtering logic to filter the data where it is greater than or equal to the variable value for the start date and less than or equal to the variable value for the end date.
B) Check to see if the X-axis format is set to Date/Time and the input format is recognized correctly, impose a filter where the X-axis is filtered to show data on or after the variable value for the start date and on or before the variable value for the end date.
C) Put a hidden data with the following formula BETWEEN( DATE( @B:B,”yyyyMMdd”), $start, $end ) and apply the filter action to select the “True” cases.
D) All of the above

8. True or False? It is better to hard code dates instead of using relative date range expressions?

A) True
B) False

9. True or False? You can use DATASOURCE with Dynamic Data Sources?

A) True
B) False

10. True or False? The MAP function with the DATASOURCE function is used when a Klipfolio variable is used in the xpath?

A) True
B) False

11. You can include a Klipfolio Date/Time function such as TODAY( ) or YESTERDAY( ) in a REST API query.

A) True
B) False

12. Seema is an admin user of a Klipfolio account, who is currently setting up other users. She can get a user invite link and a link to reset the password from the user’s settings, which can then be passed along to the users.

A) True
B) False

13. True or False? When connecting to a SQL Database, an SSH Tunnel can be used to increase security?

A) True
B) False

14. You can reference the value(s) of a component in another component in the same Klip.

A) True
B) False

15. Which of the following “units” of time can be included in the DATE_STARTOF function? Select ALL that apply.

A) Hour
B) Day
C) Week
D) Month
E) Quarter
F) Year
G) Decade
H) Fortnight

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

A) SUBSTITUTE
B) SUBSTITUTE_REGEX
C) REPLACE OR SUBSTITUTE
D) REPLACE
E) All of the above

17. Consider the following scenario. A user can change the default start day of the week when using DATE_STARTOF function when the unit parameter chosen is “day of week” or “week”.

A) True
B) False

18. In which of the following scenarios is the DATE_ADD function the optimal date function to use? Select ALL that apply.

A) To find values in the last 30 days
B) To find values in the last month.
C) To add or subtract a certain number of days from a given date
D) To find values in a given week.
E) To find values between the start of last month, and the end of the current month

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

A) SUBSTITUTE
B) SUBSTITUTE_REGEX
C) REPLACE OR SUBSTITUTE
D) REPLACE
E) All of the above

20. Replacing “view” with “debug_info” in the data source url will help you do which of the following? Select ALL that apply.

A) Manage/list dynamic data source instances
B) Change dynamic data source configuration
C) Add dynamic data source instances
D) Delete dynamic data source instances
E) Refresh dynamic data source instances
F) View data for a dynamic data source instance
G) See refresh log error messages for a dynamic data source instance
H) Download a dynamic data source instance

21. You can schedule a specific time a datasource refreshes using the Klipfolio API.

A) True
B) False

22. Which of the following formulas is the best option for SUM’ing a set of values held in Column A of multiple Dynamic Data Source instances? NOTE: The possible values for the Dynamic property is in Column B of a 2nd data source.

A) SUM(MAP(A:A))
B) SUM(B:B)
C) SUM(MAP(B:B))
D) SUM(A:A)
E) SUM(ARRAY(JOIN(MAP(B:B)))
F) JOIN(A:A)

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

A) True
B) False

24. True or False? User input controls can control data in more than one Klip.

A) True
B) False

25. You have a datasource where column A is showing a list of country names (where some names are repeating themselves). Do the function GROUP(@A:A) and the group action applied to @A:A yield the same result?

A) True
B) False

26. True or False: Dashboards published privately require a password?

A) True
B) False

27. 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 best function that Adam should use to remove the leading and trailing blanks?

A) INDEXOF
B) SUBSTRING
C) LAST_INDEXOF
D) LEFT E) RIGHT
F) SUBSTITUTE_REGEX

28. Which of the following is true of the LOOKUP function?

A) It is similar to vLOOKUP in Excel
B) Duplicate values in the 2nd parameter (“keys”) are not a problem.
C) The 1st and 2nd paramters need to evaluate to the same number of values
D) The 2nd and 3rd parameters need to evaluate to the same number of records
E) Formulas that use LOOKUP cannot be sorted
F) 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).
G) LOOKUP looks into data with duplicate values (input); deduplicates the input records (keys), and returns a summarized value based on the deduplicated data.

29. All of Klipfolio’s Date/Time functions return the results in dd/MM/yyyy format by default.

A) True
B) False

30. If you’re using the Condition tab in the filter action window, what is the difference between the “Match All” vs. “Match Any” options?

A) “Match All” is the equivalent of using AND to combine multiple conditions while “Match Any” is the equivalent of using OR to combine multiple conditions (for the same component)
B) There is no difference between the two options.
C) “Match All” is the equivalent of using OR to combine multiple conditions while “Match Any” is the equivalent of using AND to combine 49 multiple conditions (for the same component)
D) “Match All” lets you combine conditions from multiple sub-components but “Match Any” does not.

31. What is the name of the header entry that should be used for authentication when using the Klipfolio API?

A) Content-Type
B) kf-api-key
C) user_id
D) role_id

32. Keely has five Klips in dashboard 1 and wants to move three of them to dashboard 2. She can drag and drop the three Klips from dashboard 1 to dashboard 2.

A) True
B) False

33. How do you enable the option to see the Klip resizing handle, which allows you to change the size of a Klip on the dashboard?

A) Change the layout mode to custom
B) Through user roles
C) Through a setting under your account
D) All of above
E) None of the above

34. Which authentication types can be used when creating a data source using the Web Accessible Resource Connector?

A) OAuth
B) 2-Step

C) Public key infrastructure
D) Basic
E) No Authentication
F) X-WSSE

G) Biometrics

35. Meggan’s ad agency has a Klipfolio partner account, which has 20 client accounts under it. In the parent account, Group A consists of users who can access the client selection and sign into a client as admin. An admin of Meggan’s ad agency can set sharing settings such that Group A users can only see 10 clients under the client selection.

A) True
B) False

36. In a Klipfolio partner account, you can import dashboards from:

A) Parent account to a client account
B) Client account to client account
C) Client account to parent account
D) All of the above

37. Kaushi is the builder of a Klipfolio partner account, and has imported a dashboard from the parent account to a client account. She now wants to update one of the Klips in the parent account and propagate the changes to the client instance of the Klip. Under which of the following scenarios can she use the “Update client instance” button to do achieve this task?

A) Anytime a Klip has been modified (either components or styling)
B) Anytime another datasource has been added to the Klip
C) Anytime a formula has been updated in the Klip
D) Anytime formulas, components or styling of a Klip have been updated and there has been no datasource changes

38. Which of the following customization options are available with Klipfolio? Select ALL that apply.

A) White Label
B) Custom Theme
C) Domain Alias
D) Custom Data Store
E) Change Logo

39. Stephen is a builder of a Klipfolio partner account, which manages 10 clients. Also within the Facebook business manager, Stephen has permission to access insights of his client’s Facebook pages and ad accounts. He wants to build out a template Facebook dashboard in Klipfolio, which he then wants to import to his client’s accounts and have it configured to show their specific Facebook data. What is the best practice to create such a template dashboard?

A) Create static data sources where Facebook page and ad account id are hardcoded, create the template Klips using the static data sources, import the dashboard into a client account and reconfigure all the data source to change the Facebook page and ad account ids after import

B) Set the Facebook page and Facebook ad account id as company properties, create dynamic data sources which uses the company properties as variables, create the template Klips using the dynamic data sources and import the template dashboard into a client account
C) Don’t bother with importing a dashboard, build all the Klips that a specific client account needs individually
D) None of the above

40. If a Klipfolio partner wants to build a template Facebook dashboard, import to his client accounts and have it show their specific Facebook data, is this the correct order of operations for the import procedure?

Create the custom company properties first
Set their valid values
Import the dashboard

A) True
B) False

41. How many different ways can you manage the billing for your Client accounts?

A) 1
B) 2
C) 3
D) 4

42. Users in the Parent (Partner) account cannot have access to certain Client accounts

A) True
B) False

43. What are the different ways I can log into a Client Account?

A) Admin & View Only
B) Admin only
C) Admin & Editor
D) Admin, Editor & View Only

44. When importing dashboards or klips, the variables in formulas do not get imported

A) True
B) False

45. In which of the following scenarios is DATE_IN the optimal date function to use? Select ALL that apply.

A) To find values in the last 30 days
B) To find values in the current day
C) To find values between two randomly selected dates
D) To find values from “last week”
E) To find values between the start of last month, and the end of the current month

46. Pick the correct syntax of the SLICE( ) function which removes the last row from column A.

A) SLICE(@A:A, -1)
B) SLICE(@A:A, -1, 0)
C) SLICE(@A:A,0,-1)
D) SLICE(@A:A,1,-1)

47. With the appropriate Role(s) and Permission(s) a Klipfolio User can add a Klip to a Dashboard in which of the following ways? Select ALL that apply.

A) From the Gallery
B) From their Account Settings
C) From the Library
D) From scratch using the Klip Editor

E) By emailing support@klipfolio.com
F) By using the Klipfolio API

48. Ivan is writing an api query, and from the api’s documentation he finds out that the response can be filtered to only show data created since a defined date (using the “created_since” parameter). Ivan wants to filter the data that was created since the beginning of the month, and the input format of the “create_since” parameter should be “yy MMM dd”. What is the date/time function Ivan should pass to the “created_since” paramter in his query?

A) date.startOfYear.format(“yyyyMMdd”)
B) date.addMonths(-1).format()
C) date.startOfMonth.format(“yy MMM dd”)
D) date.add(-5).format(“yy MMM dd”)
E) date.addMonths(-1).endOfMonth.format()

49. How often do Klip embeds refresh?

A) Every 8 hours
B) Every 24 hours
C) Every 3 hours
D) Klip embeds do not refresh

50. It is possible to enable dark theme for all users without using custom CSS

A) True
B) False

51. True or False? A Klip must have at least one data source?

A) True
B) False

52. Fill in the blank: You can have up to __ datasources per formula.

A) 12
B) 10
C) There is no maximum limit of datasources per formula
D) 17
E) 1

53. A dynamic datasource can only have one dynamic property.

A) True
B) False

54. Which of the following can be used to control both which specific dashboards are visible to each user, and also what Klipfolio features each user has access to?  

A) Users
B) Groups  
C) Roles
D) Users and Groups
E) Users and Roles
F) All of the above

55. When you save a copy of a Klip, it duplicates the Klip and creates a copy of the datasource(s) associated with that Klip.  

A) True
B) False

56. What Klipfolio assets are stored in the Library?

A) Components, Klips, and Dashboards
B) Tabs, Klips, and Dashboards
C) Components, Klips and, Data Sources
D) Klips, Dashboards, and Data Sources
E) Klips, Connected Accounts, and Dashboards

57. True or False? A Klip component must have at least one data source?   

A) True
B) False

58. Which of the following statements are true about displaying Klipfolio on a wall-mounted screen?  Select ALL that apply.

A) Klipfolio is not designed to work on Wallboards
B) Klipfolio allows you to cycle through your dashboards in full screen mode
C) You can only display Klipfolio on a Wallboard using Published Links
D) There is no way to adjust the cycle time when displaying in full screen mode
E) By default, a dashboard is switched every ten (10) seconds
F) You can pause on a single dashboard when cycling through multiple dashboards in full screen mode.

59. Which of the following statements are true about “Roles” in Klipfolio?  Select ALL that apply.

A) There are three types of Roles in Klipfolio (out of the box): Admin, Editor, and View Only.  
B) Admin Users manage all assets, Groups, and Account Settings
C) Editors create and share assets they have access to.

D) View-only Users can view dashboards with no customization, but can view and add “Annotations”
E) Only 1 Custom Role is allowed per Account.

60. When deleting a dashboard in Klipfolio, which of the following statements are true?  

A) Deleting a dashboard automatically deletes the Dashboard and all of its Klips and data sources.
B) Klipfolio gives you the option to delete the Dashboard only or delete the Dashboard and its Klips and Data Sources.
C) Dashboards cannot be deleted.
D) All Dashboards, Klips, and Data Sources need to be deleted separately.
E) When attempting to delete a Dashboard and all of its Klips and Data Sources, if the Klips and/or Data Sources are used in other areas, they will not be deleted.

61. True or False: Full Screen Mode in Klipfolio allows you to automatically cycle through specific dashboards at a time interval that you choose.

A) True
B) False

62. Which of the following statements are true about adding Users in Klipfolio?  Select ALL that apply.

A) When you email a Klip or Dashboard to an email address, a User associated with that email address is added in Klipfolio.
B) When you create a User in Klipfolio you provide an email address, and the system sends the new user a notification email
C) A single email address can only be associated with a single Account in Klipfolio
D) Users can be created through the Klipfolio API

63. What types of data formats are supported by Klipfolio?   

A) Excel
B) CSV
C) JSON
D) XML
E) All of the above
F) None of the above

64. Consider the following statement: Datasources in your KIipfolio account refresh only if there is an active session (such as a user being logged into the Klipfolio account or a published link being used).

A) True
B) False

True or False? A User can only be part of one Group.

A) True
B) False

Klipfolio lets you connect to how many different web based data sources?   

A) Five: Excel, Facebook, Twitter, Salesforce, Google Analytics
B) We can connect to and fetch data from 1000s of different services.
C) 450 Different services with REST APIs that use OAuth.
D) 40-50: Those listed in the Klip Gallery

True or False? Klipfolio only offers dedicated Connectors (ie., for Google Analytics, Salesforce, Twitter, etc.) for services included in the Klip Gallery.   

A) True
B) False

Rupert has a 12 MB Excel file that he wants to upload to Klipfolio. He can do this by using the Klipfolio API.   

A) True
B) False

Using the image below, what properties can you tell have been set for the map markers?   

A) Latitude, Longitude, Colour, Size, Name, and Description
B) Latitude, Longitude, and Size
C) Latitude, Longitude, Size, and Colour
D) None of the Above

True or False? Only Admin Users in Klipfolio can create variables?   

A) True
B) False

You can have multiple components in a single Klips.   

A) True
B) False

If you want to change the data in a Klip based on a variable then the variable needs to be in which parameter of the SWITCH function?   

A) data
B) case
C) values
D) All of the above
E) None of the above since you cannot use variables in a SWITCH statement

Abdul has built a pie chart Klip which shows the number of sessions per Google Analytics channel. He wants to only show the channels which have more than 100 sessions in the pie chart. Abdul can achieve this using filter actions as follows: select the filter option for the values component of the pie chart; if a group action is applied to the labels, make sure the values have the correction aggregation method; set a condition filter to select values that are greater than 100 and check to see that the values in view option is selected.   

A) True
B) False

Josh wants to show websites and time on website in a table. He wants to set time on website metric to format as duration (hh:mm:ss). What should be the format of his raw input data?   

A) In hours
B) In seconds
C) In minutes
D) All of the above

True or False? Bar/Line Charts cannot show negative values.

A) True
B) False

A pie chart can only have a maximum of 6 slices.   

A) True
B) False

When plotting markers on a Map component, these two data points are required:  

A) Name and Latitude
B) Latitude and Longitute  
C) Latitude and Colour  
D) Colour and Size
E) Longitude and Size

DJ The Tassmanian is working on a Klip that lists his upcoming shows with a dynamic datasource and sees the following message: “A problem occurred while loading the datasource. Please try reloading the page.” He suspects that there is a bad dynamic datasource instance causing this error message. What is the process he should take to verify this?   

A) Reconfigure the datasource
B) In the display url of the of the datasource, replace “view” with “debug_info”
C) Latitude and Colour  
C) Log out of Klipfolio, go for a coffee and log back in
D) All of the above

Which of the following are types of user input controls?  Select ALL that apply.

A) Date Picker
B) Multiple select drop-down list  
C) Drop-down list  
D) Text field
E) Date range

To use a variable in a Klip, you must have:  

A) Set up a User Input Control, User Property, or Company Property, with an assigned variable, and use this variable in the Klip formula  
B) Set up a User Input Control and a Submit Button, with an assigned variable, and use this variable in the Klip formula.
C) Have a dynamic data source, with an assigned variable, and use this variable in the Klip formula.
D) Used the syntax: {var.’variable name’}, with an assigned variable, and use this variable in the Klip formula.

Which of the following statements are true?  Select ALL that apply.

A) You can only change the default value for a user input control if the Klip has not yet been saved.
B) You cannot change the scope once the variable has been set.
C) The Labels in a drop-down list must be different from the Values.  
D) You can choose to set the value of an input control instantly or with a button component.

Seth is building a table component. Column 1 of his table has 10 entries and a hidden data component has 20 entries, how many rows does Seth’s table have?   

A) 10
B) 20
C) 11
D) None of the above

Keely is building a bar/line chart with dates in the X-axis, the input format of the dates is yyyy-MM-dd and Keely has set the output format to MMM dd, yy. If she uses a results reference to the X-axis in another component, it will show dates in yyyy-MM-dd format.   

A) True
B) False

Consider the following scenario: Tass is creating a dynamic datasource where he needs to pass variable values to “start-date” and “end-date” parameters of the query. He can pass the variable values under the “Query Parameters” section of the connector as follows:

A) True
B) False

Zeek is using the following Klipfolio date function to specify the “start_date” parameter in his api query: {date.add(-5).startOfMonth.format(“yyyy MMM dd”)}. If today is December 3, 2017, what is the value that is being input into the “start_date” parameter?  

A) Dec 1, 2017
B) 2017 December 1
C) 2017 December 01
D) 2017 November 01
E) November 1, 2017
F) None of the above

Formulas referenced by !REF are fully recalculated; therefore, no performance saving is gained when using !REF.  

A) True
B) False

You have a datasource where column A is showing a list of country names (where some names are repeating themselves). You apply a member filter check-boxes to include the following countries: Canada, England, Poland and India. When the datasource refreshes Brazil is newly added to it. What happens to the component using the filter when new data is added to it?  

A) Canada, England, Poland and Brazil will be shown.
B) Canada, England, Poland, India and Brazil will be shown.
C) Only Brazil will be shown.
D) Canada, England, Poland and India will be shown.

You have a datasource whose column A contains date/time in unix format. You wish to display the date in the calendar format of MMM dd, yyyy but you also wish to include the hour and minute information (with a separator of :). How do you specify the time to match the requirement above?  

A) HH:MM
B) hh:MM  
C) hh:mm  
D) HH:mm  
E) c and d  
F) None of the above

The DATERANGE function can be used to populate an X-axis with all the dates between a given start and an end date.  

A) True
B) False

You can pass the timezone as a parameter to the NOW( ) function.  

A) True
B) False

Josephine from accounting is writing a formula using the SELECT( ) function. She wants to select payroll data to match the following conditions: the paydates must fall within the current year and the employee type must be equal to full time. However, it is only possible to have one condition in the SELECT( ) function.  

A) True
B) False

How do you define a variable in the second parameter of a MAP/MAPFLAT function?  

A) “variable_name”
B) $variable_name
C) &variable_name
D) {props.variable_name}

What is the default aggregation method for the third parameter of GROUPBY() function?  

A) Sum
B) Average
C) Count  
D) Join
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

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

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

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

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

What function would you use to combine multiple true/false conditions?

A) AND
B) IF
C) MAP
D) BETWEEN
E) CONTAINS

How do you get the element names for a list of elements in a JSON or XML data source (such as the country codes in Facebook)? Select ALL that apply.  Note: One answer is better than the others, and is therefore worth more.

A) kf:names(/records/countries/)

B) name(/records/countries/)
C) MAP(COMMULATIVE(REPEAT ( 1, COUNT(/records/countries/)),”index”,DATASOURCE(1ed56f…,CONCAT(“name/records/countries[“,index,”])”) D) /name/records/countries//*

What are some constructs you can use to help solve the issue where the JSON data source does not have values for all elements and therefore the data does not line up correctly in the Klip?  Select ALL that apply.

A) Use LOOKUP function to lookup from complete list of ids to list of ids that have a picture
B) Use the following-sibling or preceding-sibling constructs in the xpath
C) Use the custom kf:fill_elements function

D) Use the MAP function to iterate through each item and SELECT only the items that do have values for all elements

You can add a user to a Klipfolio account without sending them an invite notification email.  

A) True
B) False

Consider the following scenario. You can find the refresh info for a given datasource (including any errors) by going to the information section of the datasource and selecting the “Refresh Info” link from the options available on the left-hand side.  

A) True
B) False

Shima is creating a Klip and wants to have a dynamic datasource whose query is identical to an existing static datasource. She should not change the parameters of the existing static datasource to dynamic ones or duplicate the static datasource and replace the parameter values with variables (i.e. {props.}). Instead, she should create a brand new dynamic datasource.  

A) True
B) False

What function do you use to convert a date string into “epoch time” in order to perform a calculation? NOTE: Epoch time is a computer readable date string. It is the number of seconds that have elapsed since Jan 1 1970. 

A) DATE
B) DATE_CONVERT
C) DATE_VALUE
D) SINCE
E) UNIX

What are the assets within a Klipfolio account that can be duplicated?  

A) Dashboards
B) Klips
C) Datasources
D) Dashboards, Klips and Datasources
E) Klips and Datasources

A custom company property is considered a variable  

A) True
B) False

Igor created a multi-component Klip yesterday, which contained 3 gauges and 1 table. Today, he removed the table component from the Klip but after reviewing it, he wants to revert to the original version of the Klip. Igor can revert back to a previously saved version of the Kilp by going to the “View Recent Revisions” options from the drop-down menu on the top right corner of the Klip editor.  

A) True
B) False

An admin of an account has access to the authentication tokens of all users, whether they were shared or not.  

A) True
B) False

Which of the following are valid methods for creating data sources in Klipfolio?  Select ALL that apply.

A) Upload a file
B) Create a data source using the “Web Accessible Resource” connector
C) Use a pre-built connector for services like Xero, Google Analytics, Facebook, etc.
D) Email data to Klipfolio

E) Send data to Klipfolio via SMS  
F) Connect directly to an SQL or XMLA database
G) Connect to a cloud storage service like Dropbox; Box; or Google Drive
H) Use the Klipfolio API


Leave a Reply

Your email address will not be published.