Instantly download Analytics-Con-201 updated real questions

Salesforce Analytics-Con-201 Exam Overview:

Salesforce Analytics-Con-201 Exam Syllabus Topics:

Salesforce Certified CRM Analytics and Einstein Discovery Consultant Sample Questions:

1. Exhibit.

Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:
YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.
What is the correct function to use?

A) replace()
B) substr()
C) coalesce()

2. A consultant runs the sharing inheritance coverage assessment for the Opportunity object and finds that some records exceed 400 sharing descriptors.
What should the consultant do?

A) Contact Salesforce Support to increase the sharing descriptor limit.
B) Increase the sharing descriptor limit in the analytics settings.
C) Use security predicates in CRM Analytics.

3.
Which timeseries statement will fix the query?

A) q = timeserles q generate 'sum_Sales' as 'Forecasted_Sales' with (length=12,dateCols=("Date_Year',
'Date_Month', "Y-M"), partition='Region');
B) q = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=('Date_Quarter',
'Date_Month', "Q-M"), partition='Region', ignoreLast=true);
C) q= timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=('Date_Year', 'Date Quarter', "Y-Q"), partition='Region', seasonality=4);

4. A CRM Analytics consultant at Cloud Kicks is trying to upload data using an External Data API and the CSV file with the data wasuploaded successfully. Upon analyzing the data using a lens, they find they are unable to perform any mathematical operations as all the data and fields are treated as dimensions.
What is causing the problem?

A) Proper transformations need to be performed at the external source prior to External Data API callout.
B) JSON metadata file was not uploaded along with the CSV data file.
C) The field value added in the CSV file was contained within double quotes.

5. Universal Containers' CRM Analytics team is building a dashboard with two widgets, and the queries use different datasets.
1. List widget associated to the query "Type_2" and grouped by the dimension "Type" (multi-selection)
2. Donut chart widget associated to the query "Query_pie_3" and grouped by the dimension "Type" The team wants any selection in the List widget to filter the Donut chart and vice versa. Users should be able to choose more than one Type (multi-selection).
What is the recommended way to accomplish the required filtering?

A) Create a selection based Interaction and apply It to the query of "Query ple 3".
B) Set up a result and selection based interaction for each query.
C) Use "Connect Data Sources" to create a mapping of the two fields from the two datasets.

Solutions: