A CRM Analytics consultant has been asked to refactor a dashboard so that it loads quicker. After some analysis, the consultant found that most of the dashboard queries run in less than 5 seconds; however, the Opportunities Table takes more time to load when scrolled down from its initial view.
How should the consultant improve the performance of this dashboard?
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 theyare unable to See this new valueson their existing dashboards.
What is the oridi4 of this issue?
Which capability can a consultant use if “Deploy without connecting to a Salesforce Object†is selected while deploying the model?

A data architect wants to use a recipe transformation to implement row level security based on role hierarchy in Salesforce.
Which transformation should the architect use to level the dataset hierarchy?
The sales team at Cloud Kicks is requesting that datasets for their dashboards be refreshed every hour. The CRM Analytics consultant investigates if this is possible and finds that the dashboards use five datasets created from two recipes. The first recipe takes 43 minutes to run and the second recipe takes 25 minutes to run.
Which consideration should the consultant keep in mind?
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 CRM Analytics consultant is asked to make sure the new sales performance dashboard is accessible in the mobile app. They have created multiple mobile layouts for the same dashboard.
How is CRM Analytics expected to perform?
A consultant runs the sharing inheritance coverage assessment for the Opportunity object and finds that some records exceed 400 sharing descriptors.
What should the consultant do?
CRM Analytics team is asked to build a Service Analytics dashboard for the service agents.
What are the main "Deep Design Thinking" principles the team should keep in mind during the discovery sessions?
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?

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?
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?
Universal Containers plans to upload target data from an external tool to CRM Analytics so it can calculate the sales team target attainments.
The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep, the file contains a target for every month of the current year as well as all previous years.
Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?
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?
Universal Containers has a dashboard for sales managers that want to visualize their win rate.
Which chart type should the consultant use to keep track of targets?
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?
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?
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?
A user is able to access the dashboards, lenses, and datasets of a particular app but is unable to change the name of the specific app.
What is causing the issue?
Which recommended technique should a CRM Analytics consultant
use to access CRM Analytics data from a remote app or website?
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 model created with a GLM algorithm produced unsatisfactory results.
When re-running the model, which type of algorithm should the consultant use to improve the results?
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?
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?
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?
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?
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?
Several users are complaining they are unable to see a specific dashboard on a Salesforce Lightning page anymore. The CRM Analytics consultant logs in as one of the users and sees an error
page once the dashboard is opened.
How should the consultant solve this issue?
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?
A consultant creates a CRM Analytics dashboard in a sandbox and it needs to be migrated into production.
What should the consultant use to complete the migration?
A manager at Cloud Kicks wants to separate and analyze accounts based on numeric information of its opportunity records. The data includes things like amount, quantity of products, contacts, and
quotes.
How should the CRM Analytics consultant accomplish this?