Month End Sale - Special 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 75onlydt

Analytics-Con-201 Questions and Answers

Question # 6

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?

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.

Full Access
Question # 7

Cloud Kicks (CK) has a dashboard that is still showing 10 former account managers. CK has since expanded, and some have moved from their former roles. CK wants the dashboard to reflect current account managers and stay up to date as new team members join.

How should the CRM Analytics developer accomplish this?

A.

Use a Repeater Widget that updates automatically as the data flows through the system.

B.

Create @ Watchlist and when the number of account manager updates, update the dashboard to reflect the same.

C.

Build a report and get notified when a new account manager joins, and then edit the dashboard to add the account manager.

Full Access
Question # 8

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

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.

Full Access
Question # 9

In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in

green; a value of false should result in the display of the word "No" in red.

How should the consultant accomplish this?

A.

Create an XMD node in the recipe to change the label and color of the values in the fields.

B.

In the explorer's field panel, select the boolean fields and use the "edit values” option on the fields to change values and colors.

C.

Select the boolean fields in the explorer's field panel, select the boolean fields, then create a derived dimension.

Full Access
Question # 10

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?

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

Full Access
Question # 11

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?

A.

Flatten

B.

Custom Multiple row formula

C.

Custom Formula

Full Access
Question # 12

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?

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.

Full Access
Question # 13

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?

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.

Full Access
Question # 14

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?

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.

Full Access
Question # 15

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?

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.

Full Access
Question # 16

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?

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.

Full Access
Question # 17

Universal Containers uses CRM Analytics to build dashboards for different departments: Sales, Service, and Marketing. Users in the samedepartment have the same role and need to have access to the same dashboards. Dashboards for different departments use some common datasets with the same row-level security.

How should a CRM Analytics consultant address this need?

A.

Create one app for each department, put common datasets in the shared app, and use roles to share apps.

B.

Create one app for each department, put common datasets in the shared app, and use profiles to share apps.

C.

Create one app for each department, put common datasets in the shared app, and use permission sets to share apps.

Full Access
Question # 18

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?

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.

Full Access
Question # 19

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?

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.

Full Access
Question # 20

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?

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.

Full Access
Question # 21

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.

Question # 21

Which widget parameters should a consultant use?

A.

Range Values, Angle, Conditional Formatting

B.

Reference Line, Angle, Range Values

C.

Reference Line, Markers, Conditional Formatting

Full Access
Question # 22

In Data Alerts, a field named Region is 96.5% North America. The consultant believes that this is an important field since the majority of sales is in the North American market.

What is the appropriate action?

A.

Choose the recommended action “keep only North America” and exclude all of the other rows.

B.

Understand if client should only "focus on North America” or drop the field, as it does not have valuable information.

C.

Append more rows of data with "other values of Region” to balance the dataset properly.

Full Access
Question # 23

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?

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.

Full Access
Question # 24

The CRM Analytics consultant at Cloud Kicks (CK) notices that a specific dashboard is showing a different date and time from their locale. Upon investigating, they find that the recipe and datasetswere created from a locale with a PST time zone while CK is in the CET time zone.

What led to this problem?

A.

The developer turned off dynamic time zone in CRM Analytics settings.

B.

Data within datasets is modified for localization or internationalization.

C.

The dataset metadata locale Is not overridden by Individual user locale settings.

Full Access
Question # 25

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?

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

Full Access
Question # 26

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?

A.

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

B.

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

C.

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

Full Access
Question # 27

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?

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.

Full Access
Question # 28

Question # 28

Which timeseries statement will fix the query?

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);

Full Access
Question # 29

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?

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.

Full Access
Question # 30

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?

Question # 30

A.

Creating a supplementary dataset and utilizing dataset joins.

B.

Deploying without connecting to a Salesforce object.

C.

Adding actionable variables to the model.

Full Access
Question # 31

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?

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.

Full Access
Question # 32

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?

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.

Full Access
Question # 33

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?

A.

App

B.

Dataset

C.

goats

Full Access
Question # 34

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?

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.

Full Access