Weekend Sale Special - 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: big75certs

Free and Premium Salesforce Analytics-Con-201 Dumps Questions Answers

Salesforce Certified CRM Analytics and Einstein Discovery Consultant Questions and Answers

Question 1

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?

Options:

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.

Buy Now
Question 2

ACRM Analytics consultant is reviewing results from an Einstein Discovery story with a business user. They agree with the findings but notice that none of the fields used in the story have a correlation value greater than 4%. The client is now concerned that the model

may not be good enough to deploy.

Which action should the consultant take?

Options:

A.

A Identify additional data that may have a stronger relationship with the outcome variable.

B.

Edit the model accuracy settings and rerun it to evaluate the correlation.

C.

Use the appropriate algorithm and update the model.

Question 3

CRM Analytics team plans to enable data sync.

Which limit specific to data syne should the team consider before enabling the feature because it may impact existing jobs?

Options:

A.

Maximum number of data sync jobs cannot exceed the limit

B.

Maximum number of Full Sync connection mode enabled

C.

Maximum number of objects that can be enabled for data sync

Question 4

A CRM Analytics consultant wants to move a dataflow to a recipe in order to use aggregation nodes. To do so, they use the Dataflow to Recipe convertor and the recipe runs successfully.

However, they are unable to see the aggregated data in the dataset.

What is causing the issue?

Options:

A.

The recipe has to be turned off and only the dataflow should run.

B.

The dataflow has to be turned off and only the recipe should run.

C.

The convertor has created a new dataset with a new ID.

Question 5

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

Question 6

Which timeseries statement will fix the query?

Options:

A.

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

B.

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

C.

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

Question 7

A client has two datasets that are used across seven different dashboards. Three of these dashboards are used by marketing and four are used by sales. The client requires that only marketing can

access the marketing dashboards and only sales can access the sales dashboards.

Which solution should a consultant recommend?

Options:

A.

Create three custom apps: one for marketing dashboards with marketing as "viewer", one for sales dashboards with sales as "viewer", and one for datasets where marketing and sales are "viewer".

B.

Duplicate the datasets and create two custom apps: one for marketing dashboards and datasets with marketing as “editor” and one for sales dashboards and datasets with sales as "editor".

C.

Use two custom apps: one for marketing dashboards with marketing as "viewer" and one for sales dashboards with sales as “viewer". Add the datasets as references to both custom apps.

Question 8

Universal Containers has a dashboard for sales managers. They need to visualize the percentage of their opportunities in the pipeline in a Gauge chart. They want to customize the chart to keep track if they are below or beyond the target.

Which widget parameters should a consultant use?

Options:

A.

Range Values, Angle, Conditional Formatting

B.

Reference Line, Angle, Range Values

C.

Reference Line, Markers, Conditional Formatting

Question 9

A CRM Analytics consultant is asked to help a company report on its sales activity. The company wants to train some users to create dashboards. The company also wants one other specific team to be able to use the dashboards.

What should the consultant do to address these requirements?

Options:

A.

configure a permission set license assignment with two different levels of access.

B.

Clone the existing permission set with different system permissions.

C.

Use a permission set license with two different levels of access.

Question 10

A CRM Analytics consultant at Cloud Kicks wants to create a new dashboard that uses custom GeoJSON to display data; however, they are unable to upload the file via the user interface (UI).

Which action should the consultant take?

Options:

A.

Add the system permission "Manage Analytics Custom Maps" to the permission set used.

B.

Enable Custom maps with GeoJSON"” in the analytics settings.

C.

Upload the GeoJSON via the API because it is NOT a function in the UI.

Question 11

At Universal Containers, a dashboard is built to track sales metrics. The Opportunity amount field has conditional formatting added — it turns green for closed won and red for closed lost.

How should a CRM Analytics consultant enhance the dashboard design to become more accessible to users with color vision challenges?

Options:

A.

Position Alt Texts next to the KPIs to make itmore understandable.

B.

Add up and down arrow next to the KPIs to make it more understandable.

C.

Make the numbers bold to emphasize whether it is won or lost.

Question 12

The CRM Analytics consultant at Universal Containers has set data syncs and recipe runs back to back. However, they notice that the data syncs and recipe run jobs fail repeatedly. Upon investigation,

they realize the data syncs and recipes are tightly coupled which leads to too many runs being queued and eventually being canceled.

How should the consultant resolve this issue?

Options:

A.

Raise a case with Salesforce Support to help Increase the concurrency limits of the org.

B.

Set up failure notifications so that the CRM Analytics consultant gets notified when this happens and can fix the Issue.

C.

Enable priority scheduling to automatically queue shorter or smaller runs before longer or larger ones.

Question 13

Cloud Kicks (CK) has a dashboard in CRM Analytics with forecasting data. 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?

Options:

A.

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

B.

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

C.

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

Question 14

A CRM Analytics consultant has been asked to bring data from an external database as well as five external Salesforce environments into CRMAnalytics. 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?

Options:

A.

Total number of enabled objects

B.

Salesforce external connector number of synced rows

C.

Storage rows of data

Question 15

After the initial creation of a model, the first model insight explains

93% of the variation of the outcome variable. This is unusually high.

What is the most likely reason for this?

Options:

A.

The dataset contains multiple dominant values.

B.

The model contains too many outlier values.

C.

The outcome variable may be causing data leakage.

Question 16

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?

Options:

A.

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

B.

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

C.

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

Question 17

The CRM Analytics project team at Universal Containers is creating an app with dashboards, datasets, and lenses. The app has been shared with multiple users with Viewer, Editor, and/or Manager

access.

One end user is unable to view the dashboard watchlist that was previously set up. They are receiving a “Resource not found” error while trying to access the dashboard. The team confirms that the end

user has Viewer access to the app but the project team is able to view the dashboard.

What is the reason for this error?

Options:

A.

The dashboard is deleted by a user with Manager access to the App.

B.

The dashboard has been hidden by a user with Manager access to the App.

C.

The dashboard or App permission needs to be updated to Editor.

Question 18

A CRM Analytics consultant is asked to make changes to the current sales dashboard at Cloud Kicks. The dashboard is crucial to track the daily sales performance of the company and needs to be

available for other users while the consultant works on the changes.

How should the consultant proceed to update the dashboard?

Options:

A.

Wait for a period of least usability or the dashboard to edit it.

B.

Self assign as a dashboard publisher and make the changes to the dashboard in draft mode while maintaining a previous version live.

C.

Clone the dashboard to a new one, apply the changes, share the new dashboard with the users, and delete the old one.

Question 19

Cloud Kicks uses CRM Analytics for its sales reporting. A new manager needs access to CRM Analytics to see specific dashboards.

How should the system administrator give access to the Analytics

Studio app in the App Launcher?

Options:

A.

Assign the CRM Analytics User permission set to the manager's user.

B.

Share the Analytics Studio app to the user's profile.

C.

Change the profile of the user to one that has access to the Analytics Studio.

Question 20

A CRM Analytics consultant is working on Sales dashboards with multiple datasets and advanced queries in the Sales Analytics app.

Sales managers in the organization have been given Editor/Manager access to the app, whereas sales reps have been given Viewer access.

Some dashboards that are in progress are not ready to be rolled out to sales reps and should only be viewable by sales managers.

How should the consultant accomplish this?

Options:

A.

Remove the dashboard from the ‘Run App’ navigation list so the sales reps cannot navigate to these dashboards.

B.

Duplicate the dashboards and their respective datasets, and move the assets to a separate app for the sales rep.

C.

Leverage the CRM Analytics asset visibility feature to hide the assets from the users.

Question 21

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?

Options:

A.

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

B.

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

C.

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

Question 22

For a story created using multiple data sources (Salesforce, CSV, and external data), what is a possible fix for the issue shown in the prediction?

Options:

A.

Creating a supplementary dataset and utilizing dataset joins.

B.

Deploying without connecting to a Salesforce object.

C.

Adding actionable variables to the model.

Question 23

Which statement best describes how to ensure CRM Analytics dashboards are easily used across both desktop and mobile devices?

Options:

A.

Create multiple layouts and reorder all the widgets so that they fit nicely within the new default width

B.

Create multiple layouts and allow CRM Analytics to automatically select and organize dashboard contents to be optimal for the device type.

C.

Create multiple layouts, ensure the layout selectors match the device, and resize/hide widgets to ensure the content is appropriate for the device screen size.

Question 24

AW Computing will start using Tableau Online to report on some of its Salesforce data to users who do NOT have an SFDC license.

What is the first step the CRM Analytics consultant should take?

Options:

A.

Use MuleSoft to generate an API ta connect and push data from SFDC to Tableau.

B.

Select the output connection in the “write to” option of the recipe.

C.

Enable the Tableau output connection in the Analytics settings.

Question 25

Universal Containers (UC) has a "Sales Manager” dashboard. UC has a compare table that has multiple groupings and columns added showing the Total and Subtotals of the numeric values. A consultant is

asked to add additional groups to enhance details about UC's customers.

Which feature should the consultant use to make the navigation of the compare tables easier for the end user?

Options:

A.

Create the table using SAQL query to accommodate this and make It user friendly.

B.

Select the Enable Expand or Collapse option from the table properties.

C.

Scroll to the very end to see the details.

Question 26

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?

Options:

A.

JSON metadata file was not uploaded along with the CSV data file.

B.

The field value added in the CSV file was contained within double quotes.

C.

Proper transformations need to be performed at the external source prior to External Data API callout.

Question 27

A team of CRM Analytics developers has been working on an existing recipe to add new derived fields. The edited version has been failing ever since, and management is requesting that the dashboard show refreshed data while they work on the edits.

How can the developers add new fields while keeping the dataset refreshed?

Options:

A.

A recipe for the new fields and when that is successful, add it to the existing recipe as a join node.

B.

Clone the existing recipe to add fields and roll back the original recipe to the last working version.

C.

Refresh the dataset after working hours to avoid the edited version from failing.

Question 28

Universal Containers intends to use a custom Salesforce big object in its org and visualize the data using CRM Analytics. As the number of rows to be synced is quite large, the CRM Analytics consultant is looking to set up an incremental sync with additional filters added as part of the data sync to improve performance.

What should the consultant keep in mind while implementing this?

Options:

A.

Incremental data syne Is NOT supported for big objects.

B.

Custom big objects are NOT supported by CRM Analytics.

C.

Only SOSL queries can be used as data syne filters.

Question 29

A company realizes it has a lot of rich information around its cases, but unfortunately, most of this isunstructured/textual data. Thecompany is exploring how to include some of this information in its case prioritization.

Which option within CRM Analytics should a consultant leverage?

Options:

A.

Bucket transformation in Recipes

B.

Cluster transformation in Recipes

C.

Detect Sentiment transformation in Recipes

Question 30

Cloud Kicks has informed CRM Analytics developers that they have two scenarios with restricted row-level security.

The parameters being:

1. Non-CXOs and VPs working in EMEA can have access to EMEA records only.

2. CXOs and VPs should have access to all data irrespective of the region (APAC, EMEA, etc.).

Which sharing method works for this scenario?

Options:

A.

Create two sets of dashboards; one for EMEA, and one for CXOs and VPs while filtering the dashboard on the region.

B.

Use a field on the user record like Department/Region, and apply row-level security based on that field.

C.

Create two separate datasets; one for EMEA, and one for CXOs and VPs.

Question 31

A project team member uploads a CSV file to CRM Analytics, and they notice a few records failed during the upload. The manager wants to view the error log generated so this can be fixed and uploaded again. The manager has the CRM Analytics administrator permissionbut is unable to download the error log details.

Why is the manager unable to download the log details?

Options:

A.

They do not have the Upload External Data to CRM Analytics permission enabled.

B.

They do not have the Download CRM Analytics Data permission enabled.

C.

Only the user who uploaded the external data file can download the error log.

Question 32

A CRM Analytics administrator is working on deploying a dataflow and a dataset (generated by this dataflow) to another org.

While creating a change set, they notice that the components are NOT visible to be included in the change set.

What is the reason for this?

Options:

A.

The administrator does NOT have system administrator permission to include the assets In the change set,

B.

Assets are kept in the Private App and are unavailable to include in the change set.

C.

The administrator does NOT have access to the assets on CRM Analytics.

Question 33

A CRM Analytics consultant has prepared a CSV file to be uploaded to CRM Analytics. By mistake, one of the column headers is modified as random non-alphanumeric characters "* & **( & *(%", which went unnoticed prior to uploading the file.

What is the expected behavior of the uploaded CSV column?

Options:

A.

The columnheaderis prefixed with "X" upon upload.

B.

The column header is auto-updated to “Column” + column number.

C.

The column header Is set to * & **( & *(%.

Question 34

A system administrator at Cloud Kicks creates a joined report to showcase the new business deals closing in the current quarter, which was well received by the business stakeholders. A manager wants to visualize this report on CRM Analytics.

The CRM Analytics consultant determines the report can be trended on CRM Analytics, but it's not working as expected.

What is causing the issue?

Options:

A.

Trending dashboards cannot be created from joined reports.

B.

The Salesforce report was filtered on quarterly data which meant it did not have enough data to trend on CRM Analytics.

C.

The Analytics Integration user did not have permission to view the report on Salesforce.