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

Question 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?

Asubstr()

Bcoalesce()

Creplace()

Answer : B

Question 2

A CRM Analytics consultant has been asked to bring data from an external database as well as five external Salesforce environments into CRM Analytics. Twenty-five objects have been enabled from the local Salesforce connector.

The requirements are:

* 10 objects should be enabled from an external database

* 12 objects each from three of the external Salesforce environments

* 15 objects each from the remaining two external Salesforce environments

The consultant estimates each connector will, per object, bring between 1,000 and 1 million rows of data.

Which limit will be exceeded?

ATotal number of enabled objects

BSalesforce external connector number of synced rows

CStorage rows of data

Answer : A

In evaluating the scenario presented where multiple external sources and objects are being integrated into CRM Analytics, we need to consider the total number of enabled objects across all connections. Here's a breakdown:

10 objects from an external database

12 objects each from three external Salesforce environments, totaling 36 objects

15 objects each from two external Salesforce environments, totaling 30 objects

25 objects already enabled from the local Salesforce connector

This brings us to a total of 101 objects enabled, which may exceed typical limits on the number of objects that can be enabled in a CRM Analytics environment, depending on the specific Salesforce licensing and platform limits.

Question 3

Cloud Kicks (CK) has a dashboard in CRM Analytics with forecasting dat

a. One widget is a compare table using the timeseries function showing the quarterly forecast. However, CK is interested in enhancing the dashboard with a weekly forecast per customer.

How should CK achieve this?

AAn SAQL query with a timeseries statement specifying Opportunity Name as the partition and Y-M-W as the Date Cols

BAn SAQL query with a timeseries statement specifying Account Name as the partition and Y-M-W as the Date Cols

CAn SAQL query with @ timeseries statement specifying Account Name as the partition and Y-M-D as the Date Cols

Answer : B

To create a weekly forecast per customer, an SAQL (Salesforce Analytics Query Language) query can be used. The timeseries function generates forecast data based on a specified date range. In this case, the forecast is customer-specific, meaning the partition should be based on Account Name to ensure that the forecast is generated for each customer. The date column (Date Cols) should be set to Y-M-W to aggregate the forecast data on a weekly basis.

Question 4

A CRM Analytics consultant is updating an existing recipe.

They are looking to add a few additional fields onto the Account dataset. One of the fields to be added is a multi-select picklist field that needs to be shown as text on the dashboard.

What should the consultant do to accomplish this?

AUse the array_join multivalue runcuen co convert this field to a text prior to registering the dataset.

BUse the array multivalue function to convert this field to a text prior to registering the dataset.

CUse the string multivalue function to convert this field to a text prior to registering the dataset.

Answer : A

Question 5

Universal Containers has a dashboard for sales managers. They need the ability to visualize the number of Closed Won opportunities by month, quarter, or year, and then display the result in a single chart. A CRM Analytics consultant creates a custom query to display three values:

ClosedDate_month, ClosedDate_ quarter, and ClosedDate_year.

What should the consultant do next?

AUse result binding/interaction to update the grouping in the chart.

BUse selection binding/interaction to update the grouping In the chart.

CUse selection binding/interaction to update the measure In the chart.

Answer : B

Question 6

A new picklist value was added for the Category field on the Account object. This field is already added as part of the Account object data sync and the respective recipe that uses this field.

The CRM Analytics team reports that when they start the recipe it runs successfully with no errors or warnings, but they are unable to See this new values on their existing dashboards.

What is the oridi4 of this issue?

AThe user who runs the dataflow/recipe does not have access to the field.

BThe Integration User profile does not have access to the field.

CThere are no records in Salesforce with this new plicklist value.

Answer : C

Question 7

Cloud Kicks needs a CRM Analytics consultant to install the Appointment Analytics App. After installation, they realize the wrong field was picked and the app did not have access to a newly created field that should be used instead of the old one.

What is the first step the consultant should take to prevent erroneous dataset/dashboard creation?

ACancel running installations from Setup

BStop the recipe from running in Data Manager.

CUpdate the app with the new field after installation.

Answer : B

If the wrong field is selected in the initial setup of an app or dataset, it is important to stop any data processing activities (like recipe executions) to prevent erroneous data from being loaded into datasets and dashboards. In this case, stopping the recipe from running in Data Manager is the correct first step. Once the recipe is stopped, the consultant can update the field selection or make other necessary corrections before restarting the process.

Salesforce CRM Analytics and Einstein Discovery Consultant Salesforce Certified CRM Analytics and Einstein Discovery Consultant Exam Practice Test