Free Salesforce CRM-Analytics-and-Einstein-Discovery-Consultant Practice Test Questions

Question 1

ExhibitUniversal 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 : substr()

B : coalesce()

C : replace()

Answer: B

Question 2

Cloud Kicks' Salesforce org has multiple currencies enabled. This company's business intelligence team uses CRM Analytics to build a dataflow/recipe that creates a dataset, "OpportunityDataSet", which is populated with data extracted from Opportunity. One of the extracted fields is the standard field, Amount. Which currency will the Amount values be shown in "OpportunityDataSet"?

A : the connected user's currency

B : In the integration user's currency

C : In the currency that Is set on the “currency” attribute.

Answer: B

Question 3

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?

A : Use a "fill" statement in SAQL query with a "partition" parameter.

B : Use a “Compare Table" and add a column leveraging the “Running Total” function.

C : Use a "Compare Table" and use the "Show Totals" option.

Answer: B

Question 4

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?

A : Use a "fill" statement in SAQL query with a "partition" parameter.

B : Use a “Compare Table" and add a column leveraging the “Running Total” function.

C : Use a "Compare Table" and use the "Show Totals" option.

Answer: B

Question 5

The CRM Analytics consultant at Universal Containers notices that some users have access to sensitive data and dashboards they should not have access to in the Manager's app. How should the consultant fix the problem?

A : Develop separate dashboards and datasets and put them in the Manager's app.

B : Apply data encryption using Salesforce Shield.

C : Create separate apps, datasets, and dashboards, and share them with the proper users.

Answer: C

Free Salesforce CRM-Analytics-and-Einstein-Discovery-Consultant Exam Practice Questions 2026