Salesforce CRM-Analytics-and-Einstein-Discovery-Consultant Exam Practice Test Instant Access

Question 1

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 vers

a. Users should be able to choose more than one Type (multi-selection).

What is the recommended way to accomplish the required filtering?

AUse 'Connect Data Sources' to create a mapping of the two fields from the two datasets.

BCreate a selection based Interaction and apply It to the query of 'Query ple 3'.

CSet up a result and selection based interaction for each query.

Answer : C

Question 2

Universal Containers (UC) creates a dataset, "Book11", containing a budget per region per month for the first 6 months of the year, as shown in the graphic below. Now, UC wants to create a lens showing

the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data.

How should a CRM Analytics consultant help UC build this lens?

AUse a 'fill' statement in SAQL query with a 'partition' parameter.

BUse a ''Compare Table' and add a column leveraging the ''Running Total'' function.

CUse a 'Compare Table' and use the 'Show Totals' option.

Answer : B

Question 3

consultant is tasked with creating an opportunity dataset for a new analytics app. One requirement is to make sure users only see the opportunities they have access to in Salesforce. Opportunity records are private but shared using the role hierarchy. The consultant runs

the sharing inheritance coverage assessment and finds that the VP of sales is not covered by the sharing inheritance. The consultant decides to proceed with using sharing inheritance for the dataset.

What else does the consultant need to do?

ASet the organization-wide default for the Opportunity object to Public Read/Write.

BCreate a manual sharing rule to extend access to the VP of sales from the opportunity record.

CFlatten the role hierarchy in the recipe and set a backup security predicate based on opportunity owner and role path.

Answer : C

Question 4

Which timeseries statement will fix the query?

Aq= timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=
('Date_Year', 'Date Quarter', 'Y-Q'), partition='Region', seasonality=4);

Bq = timeserles q generate 'sum_Sales' as 'Forecasted_Sales' with (length=12,
dateCols=('Date_Year', 'Date_Month', 'Y-M'), partition='Region');

Cq = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=
('Date_Quarter', 'Date_Month', 'Q-M'), partition='Region', ignoreLast=true);

Answer : B

Question 5

Cloud Kicks has a dashboard that displays accounts and opportunities data in a table that contains actions to open the records in Salesforce. Since the company has allowed several accounts to be

created with the same names, when users try to perform actions, they are prompted with only a record ID to select, leaving the users confused and unable to act.

How should the CRM Analytics consultant solve this problem?

AInsert more fields in the dataset action 'Display Fields' so the users know which account they are acting on.

BDiscuss with the stakeholders If the action Is really necessary for the table.

CAsk the admin to start applying duplicate rules based on the account's Name field.

Answer : A

Question 6

A CRM Analytics consultant is performing column profiling on dimension column in a recipe. Newly-added rows are not being considered in the Results tab of the profile even though a sync was run for that specific object.

What is causing the issue?

AThe sample does not include changes to the connected object data within the last 24 hours.

BSync operation has not run properly with the new dimension column in the recipe.

CColumn profiling Is not applicable on a dimension column in a recipe.

Answer : A

Question 7

CRM Analytics team is asked to build a Service Analytics dashboard for the service agents.

What are the main "Deep Design Thinking" principles the team should keep in mind during the discovery sessions?

APurpose - Structure - Surface

BPriority - Logic - Level of Granularity

CClarity - Efficiency - Consistency

Answer : A

Salesforce Certified CRM Analytics and Einstein Discovery Consultant Exam Practice Test