Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Salesforce CRM-Analytics-and-Einstein-Discovery-Consultant Practice Exam with Questions & Answers | Set: 3

Questions 21

A consultant creates a CRM Analytics dashboard in a sandbox and it needs to be migrated into production.

What should the consultant use to complete the migration?

Options:
A.

Analytics dashboard connector

B.

Change sets

C.

Analytics External Data API

Questions 22

Exhibit.

CRM-Analytics-and-Einstein-Discovery-Consultant Question 22

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?

Options:
A.

substr()

B.

coalesce()

C.

replace()

Questions 23

Cloud Kicks (CK) wants to use CRM Analytics to analyze trends of its sales pipeline in order to accelerate the company's sales process. To do so, CK needs to know the average time an opportunity

spends in each stage. The data can be found in the Opportunity History object, but the value is not pre-calculated in Salesforce, so a consultant recommends using a recipe to calculate it.

How should the consultant use a recipe to calculate the average time an opportunity spends in each stage?

Options:
A.

An aggregate transformation with offset parameter to calculate the duration

B.

Flatten transformation with offset expressions to calculate the duration

C.

Custom transformation with a multiple row formula to calculate the duration

Questions 24

What are various ways to incorporate blank space in a CRM Analytics dashboard?

Options:
A.

1. Use the "Cell Spacing” layout property.

2. Increase the dashboard granularity via columns, and use blank columns.

B.

Use the "Fine" row height option in layout properties, and use blank rows,

Use the "With Spacing” row height property.

C.

1. Increase the dashboard granularity via columns, and use blank columns.

Use pages to break content into multiple tabs.

Questions 25

A manager at Cloud Kicks wants to separate and analyze accounts based on numeric information of its opportunity records. The data includes things like amount, quantity of products, contacts, and

quotes.

How should the CRM Analytics consultant accomplish this?

Options:
A.

Bucket for each measure and then use a global bucket to segment accounts.

B.

Aggregate to summarize related data to account level.

C.

Cluster in the recipes and select the metrics used for clusterization.

Questions 26

A CRM Analytics consultant has enabled data sync manually in an org that uses dataflows/recipes. The client says that the dataflow/recipe fails each time it starts running.

What is causing the dataflow/recipe to fail?

Options:
A.

Dataflowsysrecipes with computeExpression nodes fail until syne has run for the first time.

B.

Dataflows/recipes with Augment nodes fail until sync has run for the first time.

C.

Dataflows/recipes with sfdcDigest nodes fail until sync has run for the first time.

Questions 27

Universal Containers (UC) is rolling out CRM Analytics to its field sales that include dashboards withorder data from an external source.

UC has a well-defined role hierarchy where everyone is assigned to an appropriate node on the hierarchy. In addition, the order data has a reference to a Salesforce opportunity.

An individual sales rep should be able to view all orders that they own or as part of the account team or opportunity team. The sales manager should be able to view all orders for the entire sales team. Similarly, the VP of sales should be able to view orders for everyone who rolls up in that hierarchy.

The dataset has a field called Ownerld which represents the order owner.

Given this information, how should a CRM Analytics consultant implement the above requirements?

Options:
A.

As part of the recipe, use a formula on the Roleid fildto create an attribute called 'ParentRolelDs' on the dataset, and apply the following security predicate: 'ParentRolelDs' ==‘’$UserRoleId’’ || Owned\ == ‘$User,id\\,

B.

As part of the recipe, use the flatten operation on the role hierarchy, create a multi-value attribute called 'ParentRoleIDs' on the dataset, and apply the following security predicate: 'ParentRoleIDs' == "$User.UserRoleld" || 'TeamMember.Id’ '$User, Id" || 'Ownerld’ == "$User.Id".

C.

As part of the recipe, use a multi row formula on the Roleld field to create an attribute called 'ParentRoleIDs' on the dataset, and apply the following security predicate:“$User.UserRoleld” || ‘Ownerld’ == “$User.Id".

Questions 28

A versioning feature allows CRM Analytics users to be added as Publishers and make changes separately while a ‘Live’ version is still being usedby other users. Once the changes are complete, the user can then set their updated version as the Live version.

Which CRM Analytics item is this leveraged for?

Options:
A.

App

B.

Dataset

C.

goats

Questions 29

The CRM Analytics consultant at Cloud Kicks is asked to a dashboard displaying Opportunities data on the account's record page. The dashboard should display only opportunity data related to the current account viewed.

How should the consultant accomplish this?

Options:
A.

Create the dashboard, insert in the account's record page, and apply a filter based on the opportunity's Id field.

B.

Create the dashboard, insert in the account's record page, and apply a filter based on the account's Id field.

C.

Create a dashboard, clone it and filter It for each account record, and embed them into the account's record pages accordingly.

Questions 30

A dashboard designer at Cloud Kicks creates a dashboard in CRM Analytics. The designer notices fields display on the dashboard with their APIlabels, such as "AccountId.Industry", and wants to change this behavior.

The designer also notices that the fields and their order appear to randomly change when a values table is created.

What should the CRM Analytics consultant explain to help the designer?

Options:
A.

The default fields in a values table can be changed by reordering how fields appear in the JSON of the value table.

B.

The default fields In a values table and the field labels can be modified in the dataset explorer.

C.

The field labels can only be changed in the widget properties in the dashboard edit mode.

Certification Provider: Salesforce
Exam Name: Salesforce Certified CRM Analytics and Einstein Discovery Consultant Exam (SP25)
Last Update: Jul 10, 2025
Questions: 115