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

Certensure Logo
  1. Home
  2. Salesforce
  3. Salesforce Consultant
  4. Analytics-Con-201 - Salesforce Certified CRM Analytics and Einstein Discovery Consultant

Salesforce Analytics-Con-201 Salesforce Certified CRM Analytics and Einstein Discovery Consultant Exam Practice Test

Demo: 34 questions
Total 116 questions
Get Analytics-Con-201 Full Access Download Analytics-Con-201 PDF

Salesforce Certified CRM Analytics and Einstein Discovery Consultant Questions and Answers

Question 1

Which recommended technique should a CRM Analytics consultant

use to access CRM Analytics data from a remote app or website?

Options:

A.

Use HTTPS to call the /wave/query API, supplying an encoded SAQL query asa parameter.

B.

Use an iFrame to embed the Salesforcepage in a remote site.

C.

Export the data to a CSV file and load it on the remote site.

Question 2

A consultant has been asked to build and embed a dashboard in a Lightning page. Users should only be able to change the dashboard contrast and open Analytics Studio from the header of

the dashboard.

How should the consultant achieve this?

Options:

A.

Deselect the "Show Share Icon" and “Enable Subscriptions” buttons.

B.

Deselect the “Enable Notifications" and “Enable Subscriptions" buttons.

C.

Deselect the “Enable Notifications” and “Enable Email” buttons.

Question 3

Universal Containers has a single dataset that contains the attainment and commission fields for all sales reps. Each sales rep should be able view the attainment data for each rep in their division. Each repshould only be able to see their own commission data.

Which option should a CRM Analytics consultant use to enforce this requirement?

Options:

A.

Utilize a single dataset and apply security predicates and/or sharing inheritance.

B.

Create separate datasets for attainment and commission, and apply security Predicates and/or sharing inheritance.

C.

Add the sales organization to the attainment dataset access list to be able to view commission data.

Question 4

A CRM Analytics consultant is building a dashboard for Cloud Kicks that is embedded in a separate Lightning page called "Management Dashboard" using a CRM Analytics Dashboard Component. The system administrator and the contract manager should both have access. The system administrator is able to see the dashboard and the data, but the contract manager sees a blank Lightning page.

What is causing the issue?

Options:

A.

The consultant has set up component visibility for the dashboard for system administrators only.

B.

The consultant has set up a dashboard filter condition for data to be visible to system administrators only.

C.

The consultant has set up/enabled a ‘Hide on Error’ feature for the dashboard while embedding it.

Question 5

Universal Containers (UC) is looking to create a dashboard for whitespace analysis. UC wants to view a particularcustomer and see what similarcustomers have bought.

Which recipe transformation is helpful for the consultant to use while creating the dataset?

Options:

A.

Timeseries Forecasting

B.

Cluster

C.

Predict Missing Values

Question 6

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?

Options:

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.

Question 7

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

Question 8

The CRM Analytics consultant at AW Computing is designing dashboard. They want to add a rate between two metrics and display it in a new chart. They are finding that the new chart seems to prejudice the design of other charts.

What should the consultant do to resolve this?

Options:

A.

Create a component with the rate chart and insert it in one of the tooltips.

B.

Clone the dashboard and replace one of the charts with the new rate chart.

C.

Adjust the dashboard widgets to accommodate the rate chart.

Question 9

The CRM Analytics consultant at Universal Containers (UC) has set up data sync for the Salesforce Opportunity object with the Amount currency field added. This is being used in multiple datasets and dashboards, as UC is a multi-currency organization.

The currency used in Salesforce records is set up in GBP but the data on the dashboard is converting to USD. Conversion logic is not set up on any of the recipes.

Why is the currency converting?

Options:

A.

The ANS local currency is set up as USD.

B.

The Integration User currency is set up as USD.

C.

The org corporate currency is set up as USD.

Question 10

A CRM Analytics administrator is working on deploying a dashboard and a dataset from a developer sandbox to a full sandbox. They have deployed the dataset via change set and manually copy-pasted the dashboard JSON into the target org. However, they notice that the conditional formatting and the widget-specific number formats have been lost in the target environment.

What is causing this issue?

Options:

A.

Analytics Dataset XMD was NOT included as part of the deployment package,

B.

The recipe that generated the dataset also needs to be included as part of the package.

C.

Analytics Dashboard XMD was NOT included as part of the deployment package.

Question 11

What is the purpose of the CRM Analytics Dashboard Inspector?

Options:

A.

To view the total time required to run all queries.

B.

To automatically remove bottlenecks to make queries run faster.

C.

To see the final query for each widget along with the results.

Question 12

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 13

An CRM Analytics consultant is working with Ursa Major Solar to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and asingle Account should only have one active subscription. The consultant notices the Opportunity record does NOT specify whether it is a renewal or a net new subscription.

Which data transformation should the consultant use to determine if a subscription is new or a renewal?

Options:

A.

Flatten

B.

Custom Multiple row formula

C.

Custom Formula

Question 14

Universal Containers asks a CRM Analytics consultant to review the performance of its local data sync.

After removing unused objects and fields from connected data, what else should the consultant do to improve performance of the data sync?

Options:

A.

Evaluate connection mode for each connected object.

B.

Contact Salesforce Support to increase sync speed.

C.

Enable fast sync in analytics settings.

Question 15

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 16

Universal Containers (UC) is using CRM Analytics to create two datasets.

* Dataset A: Contains a list of activities with an "activityID" dimension and a "userID" dimension

* Dataset B: Contains a list of users with a "userID" dimension

UC wants to delete all activities from Dataset A related to users in Dataset B.

How should the CRM Analytics consultant help UC achieve this?

Options:

A.

Use the combination of recipe transformations: "join" and “filter”.

B.

Use the recipe node "delete" and set "userID" as the deletion ID.

C.

Use the “update” transformation and utilize the "filter" node.

Question 17

A CRM Analytics consultant has been asked to add a custom object to existing recipe. When trying to locate the object, the consultant can see only Direct Data and NOT the SFDC Local data sync.

How should the consultant resolve this?

Options:

A.

Turn on data syne for the object, run the sync, and then add to recipe.

B.

Clone the recipe, add the new object to the recipe, and run the recipe.

C.

Create a new data sync connection, run the sync, and add to recipe.

Question 18

Universal Containers wants to create two dashboards and has two user groups. The 'Regional Performance’ dashboard should be accessible to sales reps and managers/executives to keep track of

how sales reps are performing in each region. Sales reps must only be able to see data pertaining to their respective region. The ‘National Performance’ dashboard is using the same data as the other

dashboard but should only be accessible to managers/executives to compare data across all regions.

In addition to row-level security to view only regional data, how should a consultant ensure that sales reps are unable to view the ‘National Performance’ dashboard?

Options:

A.

Create one dataset, two apps; store 'Regional Performance’ dashboard and dataset In one app; and provide access to both user groups to this app. Store ‘National Performance’ dashboard in another app and only provide access tomanagers/executives.

B.

Create two datasets, one app; store both 'Regional Performance’ dashboard, ‘National Performance’ dashboard, and dataset in the app; and provide access to both user groups to this app.

C.

Create one dataset, one app; store both ‘Regional Performance’ dashboard, ‘National Performance’ dashboard, and dataset in the app; and provide access to both user groups to this app. Use row-level security to restrict sales repsfrom seeing data in 'National Performance’ dashboard.

Question 19

A CRM Analytics consultant has been tasked with providing access to CRM Analytics for a few users. They should be able to view the data but unable to export it.

Which permission should the consultant make sure to NOT include?

Options:

A.

Export CRM Analytics data

B.

Download CRM Analytics data

C.

View CRM Analytics Assets

Question 20

Acompany wants to create a timeline chart to visualize the evolution of its Closed Won opportunities.

What are the required parameters to build a lens that displays output similar to the image shown?

Options:

A.

1 measure, 0 groupings if trellis Is disabled, or 0-2 groupings If trellis is enabled

B.

1 measure, 1-2 groupings if trellis is disabled, or 1-4 groupings if trellis is enabled

C.

1 measure, 1 grouping by a date field, and either 0-1 groupings groupings by a dimensionif trellis is disabled, or 0-2groupings if trellis is enabled

Question 21

CRM Analytics uses permissions of the Integration User to extract data from Salesforce objects and fields when a dataflow/recipe job runs.

Why should a consultant be cautious while syncing objects and fields containing sensitive data?

Options:

A.

The Integration User has Create and Modify All Data access.

B.

The Integration User has Modify All Data access.

C.

The Integration User has View All Data access.

Question 22

What is a benefit of introducing a second local connector?

Options:

A.

Better maintenance by having a connector per recipe

B.

Better deployment management between sandboxes and production environment

C.

Better performance by syncing data according to the refresh necessities

Question 23

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 24

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 25

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 26

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 27

CRM Analytics users at Cloud Kicks are granted access to an app with specific dashboards. When trying to download a specific widget, they are unable to do so.

What is causing the issue?

Options:

A.

The users have access to the dashboard but not the dataset.

B.

The dashboard has been created for internal use and the users have a view only license.

C.

The permission set for the users Is missing the download data permission.

Question 28

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 29

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 30

The sole manager of a CRM Analytics app at Cloud Kicks is leaving the company.

What should the CRM Analytics consultant do to ensure the app remains accessible?

Options:

A.

Assign an active user the app's manager role before the previous manager is deactivated.

B.

Deactivate the user and assign an active one to the app's manager role.

C.

Wait for the CRM Analytics app to auto-assign an active user as its manager.

Question 31

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

Options:

A.

the connected user's currency

B.

In the integration user's currency

C.

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

Question 32

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?

Options:

A.

substr()

B.

coalesce()

C.

replace()

Question 33

A consultant is building a CRM Analytics dashboard for Universal

Containers. The consultant has enabled data sync to increase the

speed of datasets refreshing.

How often will the data on the dashboard be refreshed?

Options:

A.

When dataflow/recipe runs to completion, and then data syne runs to completion

B.

When the dashboard viewer clicks the Refresh button

C.

When data sync runs to completion, and then dataflow/recipe runs to completion

Question 34

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?

Options:

A.

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

B.

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

C.

Flatten the role hierarchy in the recipe and set a backup securitypredicate based on opportunityowner and role path.

Load More Analytics-Con-201 Questions
Demo: 34 questions
Total 116 questions
Get Analytics-Con-201 Full Access Download Analytics-Con-201 PDF