Klipfolio Expert Certification Exam Answers 2019

We help you to get prepared and pass your Marketing online Certification exams. It’s a better way to learn what you need using our Top Quality Time-Saving Guides and practical tips and tricks. More info: https://www.certificationanswers.com/en/

Please note that exam question bank is much bigger. There are 180 possible questions. It means every time you take the exam, you get random questions from the question bank.

Get certified in Klipfolio Expert !

Klipfolio certifications are available in Klipfolio academy .

How often do Klip embeds refresh?

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

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

A) True
B) False

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

A) True
B) False

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

A dynamic datasource can only have one dynamic property.

A) True
B) False

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

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

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

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

A) True
B) False

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.

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.

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.

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

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

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

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

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

A) Custom CSS
B) Domain Aliasing
C) White Label
D) Custom Data Store
E) On-Premise Deployment
F) All of the above

Himadri is an admin user of a Klipfolio account and is reconfiguring a Facebook Ads datasource made by Arshad, another user of the same Klipfolio account. When she reaches the OAuth token selection step, she does not see any Facebook OAuth tokens available for selection. This is because the OAuth token used to create the datasource is owned by Mitch and was not shared with other users.

A) True
B) False

Kalyani is the owner of a start-up interior design firm and she likes to keep track of her home accessory purchases using Excel. She has built a Klip with a table component to show her most recent home accessory purchases, and wants this Klip to refresh as she updates her Excel file. Where can Kalyani store her file such that it refreshes automatically within Klipfolio and updates her Klip?

A) Google Drive
B) Microsoft One Drive
C) FTP/SFTP
D) DropBox
E) All of the above

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

A) Data sources can be used in multiple formulas but only one Klip
B) Klips can be used in multiple Dashboards
C) You can make a copy of a Klip (by saving it as a copy)
D) You can make a copy of a Data Source (by duplicating it)
E) You can make a copy of a Dashboard
F) Klipfolio separates the underlying data of a dashboard from its presentation layer, making it possible to use a single data source in many different Klips, and/or multiple different data sources in one single Klip.

What is the actual limit to the amount of data that can be used in any one Klip?

A) 10 MB
B) 120 MB
C) It depends
D) The limits on amount of data pertain to the max size of a single data source, not to a Klip.

Which one of the following are not considered a best practice?

A) Do not use nested layout grids
B) Use the IF( ) function when the condition results in true/false and use SWITCH() when the condition results in one of multiple potential values
C) Always use hidden tables to store calculations
D) When referencing a sub component for formulas, use the results reference instead of the formula reference, whenever possible
E) All of the above

Dylan is using a big screen tv to display 10 dashboards in his Klipfolio account. He wants to have more time to review a dashboard before it switches to the next one. He can achieve this by changing the dashboard switching option under his account settings.

A) True
B) False

True or False? The Labels in a drop-down list are optional.

A) True
B) False

Shima is making a table showing financial data aggregated by month. The list of aggregations for one of the table columns only has count, count distinct, first and last options. What is the cause of this?

A) There is a GROUPBY function used in that column
B) Group action is applied to the column in question
C) The format type of the column is text
D) None of the above

True or False? Variables can be used in data source queries?

A) True
B) False

You wish to refer to the “All” option from the user input control in a formula. What is the correct syntax that should be used in this case?

A) _all_
B) All
C) all
D) All of the above
E) None of the above

The following syntax can be used to specify a default function to be performed if no cases match.

A) default
B) _default_
C) (default)
D) **default**

When plotting colour data on a Map component, the map will be shaded from light to dark according to what?

A) The group of regions
B) The count of regions on the map
C) The numeric values associated to each region
D) The numeric values of the region IDs

When plotting region data on a Map component, which function is most commonly used to align data from the Region ID data source to the numeric values for each of the regions?

A) GROUPBY
B) COUNTDISTINCT
C) LOOKUP
D) MAP

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

A) True
B) False

How do you define a variable in a formula?

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

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

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

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

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

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

Can you use negative numbers in the SLICE function?

A) Yes, to “start,” or “end” the selection of data from the bottom of a data source.
B) No, you can only use positive numbers in the “start” and “end” values

Consider the following scenario: Within your Klipfolio account, you have two variables with the same name, one is “Klip” scope and the other is “All Dashboards” scope and the variable with the Klip scope has precedence.

A) True
B) False

**Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change apple to pple AND banana to bnn?**

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

What is the correct syntax for putting a variable inside of a datasource query? (ie: a dynamic datasource)

A) https//website.com/report?queryVariable={props.variable}
B) https//website.com/report?queryVariable=${{variable}}
C) https//website.com/report?queryVariable=${data[0].variable}
D) https//website.com/report?queryVariable=${GET.variable}

True or False? You can use the Klipfolio relative date range expressions if the data source you are accessing expects the start and end date in epoch format.

A) True
B) False

Which of the following relative date expressions would you use to look for “Start of the current year”? Assume this particular API expects dates in the format of yyyyMMdd.

A) {date.startOfYear.format(‘yyyyMMdd’)}
B) {date.startOfYear(‘yyyyMMdd’)}
C) {startOfYear_format(‘yyyyMMdd’)}
D) {date_startOfYear.format(‘yyyyMMdd’)}

True or False? You can click on the “Selection Options” link for an xpath element to be able to hand edit the xpath for the element?

A) True
B) False

Fill in the blank: You can have up to ____ Klips per dashboard.

A) 21
B) 9
C) 30
D) 44
E) There is no maximum limit of klips per dashboard

Which data formats does Klipfolio support when creating data sources using the Web Accessible Resource connector? Select ALL that apply.

A) Javascript
B) SOAP
C) JSON
D) XML
E) Excel
F) CSV
G) Binary

What is the best way to share a dashboard with your colleagues if they are not users of your Klipfolio account?

A) PDF of the dashboard sent out via scheduled email
B) An image of the dashboard
C) Embed of the dashboard in a HMTL component
D) A published link to the dashboard

What is the data size limit of any one data source in Klipfolio?

A) 10 MB
B) 120 MB
C) It depends
D) Unlimited

Which one of the following methods can be used to assign a value to a variable within Klipfolio?

A) MAP, MAPFLAT, SET functions
B) Company or user properties
C) User input controls
D) All of the above
E) None of the above

Which of the following statements are true regarding data sources in Klipfolio? Select ALL that apply.

A) Only the Klipfolio Support Team can change a data source refresh rate.
B) Data Sources will refresh every 15 minutes
C) The Klipfolio API can be used to trigger a data source refresh
D) With Google Analytics, 15 minutes is the shortest possible refresh interval
E) With Facebook, 30 seconds is the shortest possible refresh interval
F) Most data sources can be set to refresh as frequently as every minute
G) If a scheduled email is set to be delivered at a certain time, all data sources in the account will refresh a short time before the email is sent.
H) Data sources in a specific account will only ever refresh when at least one user is logged in, or when a Private/Public Links is viewed.

Elvira has a Klip which is utilizing a variable; however, it does not display on the dashboard. What is the most likely cause of this?

A) The server is down
B) The variable is not being set on the dashboard
C) Drill-down is enabled
D) The variable scope wrong
E) Options b and d
F) None of the above

Which of the following statements about this bar chart are true? Select ALL that apply.

A) The Blue Series only contains positve data values
B) The Green Series only contains negative data values
C) All of the bars are stacked
D) The x and y axes are inverted
E) The Orange Series is likely a REF to the Blue Series + a REF to the Green Series.
F) All of the above are true

Patrick is building a pie chart Klip for his Website Traffic dashboard using Google Analytics data. The pie chart shows sessions per channel and Patrick wants to exclude the slices of the pie chart that corresponds to “Referral” and “Paid Search” channels. The best practice for removing these channels through filter actions would be to select their names from member list and use the exclude feature.

A) True
B) False

True or False? Changing the scope of a variable from a smaller scope to a larger scope requires that you take several steps including removing, and then re-adding, the dashboard in question.

A) True
B) False

True or False? In a gauge component, Indicators override colour ranges.

A) True
B) False

True or False? In order for user input controls to change data in a Klip, the user input control must have a variable associated with it.

A) True
B) False

You can reference the value of a component in one Klip on a component in another Klip using formula or results reference.

A) True
B) False

How does White Labelling in a Partner Account affect that Partner’s Clients?

A) It allows a Partner to change the primary logo (at top left) in each Client Account
B) It allows the Partner to change the primary logo in every client Account, and completely remove Klipfolio’s name and logo from the UI of all Client Accounts
C) It allows the Partner to get a discount on White Labelling their client accounts
D) It allows a Partner to embed dashboards into their own web application

True or False? You can create custom maps in Klipfolio?

A) True
B) False

What is the difference between a filter action applied to “Values in view” vs. “Values in source”?

A) Values in source is applied before grouping while values in view is applied after grouping
B) Values in view is applied before grouping while values in source is applied after grouping
C) There is no difference between the two options
D) These options do not exist in Klipfolio.

Consider the following scenario: You have a table Klip where column 1 has the following data ARRAY(“b,a,a,a,b,b,b,c,c”) with a group action applied. What will you see if you make a formula reference (!column 1) and a results reference (&column 1) to column 1?

A) b,a,a,a,b,b,b,c,c and a,b,c,
B) a,b,c and b,a,a,a,b,b,b,c,c;
C) b,a,a,a,b,b,b,c,c and b,a,a,a,b,b,b,c,c
D) b,a,a,a,b,b,b,c,c and b,a,c

Prerna is building a bar/line chart which shows the number of social media followers acquired by month and wants to show two series from two different datasources: one to show the current year’s data and the second one to show previous year’s data. What is the function Prerna should use to align the data from two different datasources?

A) MAP/MAPFLAT
B) IF
C) DATASOURCE
D) LOOKUP
E) None of the above

Which one of the following are valid options for the prefix of the datasource email address when using Klipfolio’s email attachment connector?

A) ds
B) ds_
C) ds-
E) ds+, ds_, ds-
F) All of the above
G) None of the above

Which of the following date formats can be sorted in a chronological order?

A) MM/dd/yy
B) Unix
C) yyyyMd
D) yyyyMMdd
E) Unix and MM/dd/yyyy
F) yyyy-MM-dd
G) Unix, yyyyMMdd and yyyy-MM-dd

True or False? You can apply multiple filtering conditions to a component using hidden data.

A) True
B) False

Yvonne is writing formulas using the following Klipfolio functions: COUNT_DAYS, DATE_ADD, DATE_IN and DATE_STARTOF. What is the input date format Yvonne should use to ensure the Date/Time functions are working correctly?

A) Unix is the default, but any date format can be specified
B) yyyyMMdd
C) Unix
D) All of the above
E) None of the above

What function would you use to get a list of the unique values in a data set?

A) GROUP
B) BETWEEN
C) DEDUPE
D) TRIM
E) CONTAINS_UNIQUE

Jason is setting up users in his Klipfolio account, these users can login to Klipfolio using an external application.

A) True
B) False

Zach wants to use the Klipfolio API to upload a file. Which one of the following commands does he need to use?

A) GET
B) STORE
C) PUT
D) UPLOAD

A user group is the same as a user role, the terms are interchangable

A) True
B) False

Which of the following are legitimate ways to share a Klipfolio Dashboard? Select ALL that apply.

A) Publish a Private Link without a password
B) Manually email a dashboard to any email address
C) Share directly to Twitter
D) Share with Groups
E) Share a permalink to a dashboard with other users
F) Schedule an email to deliver a dashboard to any named user in Klipfolio
G) SMS
H) Embed an entire dashboard in a public facing website
I) Share directly to Slack

True or False? Dashboards, Klips, and Data Sources can all be shared?

A) True
B) False

You can duplicate an indicator within the same sub-component.

A) True
B) False

True or False? Any Klipfolio customer can publish dashboard links?

A) True
B) False

Which of the following are true of Klipfolio’s Klip Gallery templates?

A) They are free with all Klipfolio subscriptions.
B) They are fully editable/customizable.
C) There are both individual Klip Templates (Klip Gallery), and entire Dashboard Templates (KlipStart)
D) There are 3 comprehensive entire Dashboard Templates: Salesforce, Google Analytics, Google AdWords

Which of the following statements accurately describes the Klip Editor?

A) You can remove duplicates using a formula (group)
B) It is a browser plugin
C) It is 100% browser based web application
D) It can be purchased and used in development environments
E) You can remove duplicates through the ‘Group Repeating Labels’ option in the properties panel
F) All of the above

Klipfolio has data sources (with country, state, or provincial IDs) for which of the following maps? Select ALL that apply.

A) Europe
B) Germany
C) India
D) USA
E) World
F) China
G) APAC
H) Brazil

True or False? the SWITCH function can have multiple case and value parameters.

A) True
B) False

True or False? The Indicators panel lets you apply colour changes to values, change the background colour of cells, and assign icons based on conditional thresholds.

A) True
B) False

Mitch is building a sparkline component and wants to add a hidden data component to it. Which one of these methods can Mitch not use to add the hidden data component?

A) Properties tab of the component
B) Control panel on the right hand side
C) Right click menu of the component
D) Data tab of the component
E) None 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.

A) True
B) False

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

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. CorrectDATE — = — Used to convert a human readable date string (2015/01/01), into a computer readable date string known as Epoch or Unix time. CorrectDATEVALUE — = — Used to convert an Epoch or Unix date/time (computer readable date string) into a human readable date string (2015/01/01). CorrectDATE_IN — = — Used to find dates that fall within a given time period, like day, week, month, quarter, year. CorrectDATE_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. CorrectDATE_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. CorrectDATE_STARTOF — = — Returns the first date of a given date period, like week, month, quarter, year.

Which non-date functions could be used to find dates in a given date range?

A) SELECT and BETWEEN
A) SELECT and BETWEEN
C) SELECT and OR
D) OR and BETWEEN

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) URLDECODE
C) URLDECODE

Get certified in Klipfolio Expert !

Menu