Salesforce CRM Analytics and Einstein Discovery Consultant Practice Questions with Explanations
Free Salesforce CRM Analytics and Einstein Discovery Consultant practice questions. 19 of them, each with the correct answer, a full explanation, and the reason every other option is wrong.
CRM Analytics and Einstein Discovery Consultant practice questions
Question 1
Universal Containers (UC) uses a Microsoft Azure SQL Data Warehouse to gather information about sales reps’ objectives. UC wants to use CRM Analytics to gain insights from this data and automatically load it into a CRM Analytics dataset daily. The data also needs to be transformed and merged with data from the company’s org.
Which CRM Analytics user interface features should be used to complete these requirements?
- A. CRM Analytics Connector for Excel used in conjunction with dataflows/recipes
- B. Analytics REST API used in conjunction with dataflows/recipes
- C. Microsoft Azure SQL Data Warehouse Connector used in conjunction with dataflows/recipes
Show answer and explanation ▾
Correct answer: C
The Microsoft Azure SQL Data Warehouse connector pulls the data into CRM Analytics on a schedule. Dataflows or recipes then transform it and merge it with Salesforce data.
Why the other options are wrong:
- A. The Excel connector is for manual file uploads, not a daily automatic load.
- B. The Analytics REST API is for custom programmatic loading, not a scheduled connector.
Question 2
The CRM Analytics consultant at Cloud Kicks is asked to make sure the data on the CRM Analytics dashboard be as real-time as possible.
It was agreed to set the sync refresh time to 5 minutes for one of the local connections. The org has a CRM Analytics Plus license but users are noticing that the earliest available time is 1 hour. The minutes option is not visible to the user.
What is causing the issue?
- A. The earliest available time is 1 hour for CRM Analytics Plus license.
- B. Setting up the schedule to 5 minutes feature is not available in sandbox orgs.
- C. The consultant does not have the Edit CRM Analytics Dataflows permission assigned.
Show answer and explanation ▾
Correct answer: B
A CRM Analytics Plus license allows data sync schedules every 5, 15, 20 or 30 minutes, but that minute option is not available in sandbox orgs. So if the license is Plus and only hourly options show, the org is a sandbox.
Why the other options are wrong:
- A. A CRM Analytics Plus license is exactly what unlocks the 5, 15, 20 and 30 minute schedules, so the license is not the limit.
- C. The Edit CRM Analytics Dataflows permission controls editing, not which schedule intervals are offered.
Question 3
Which statement best describes how to ensure CRM Analytics dashboards are easily used across both desktop and mobile devices?
- A. Create multiple layouts and allow CRM Analytics to automatically select and organize dashboard contents to be optimal for the device type.
- B. Create multiple layouts and reorder all the widgets so that they fit nicely within the new default width.
- 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.
Show answer and explanation ▾
Correct answer: C
Build a layout for each device type, make sure each layout selector matches its device, and resize or hide widgets so the content fits the screen.
Why the other options are wrong:
- A. CRM Analytics does not automatically organize the layout for each device.
- B. Reordering widgets in the default layout does not make a layout for each device.
Question 4
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 selection binding/interaction to update the measure in the chart.
- B. Use result binding/interaction to update the grouping in the chart.
- C. Use selection binding/interaction to update the grouping in the chart.
Show answer and explanation ▾
Correct answer: C
A selection binding passes the user's pick from a toggle widget into the query, so it can change the grouping between month, quarter and year. The measure stays the same.
Why the other options are wrong:
- A. The measure is Closed Won opportunities in every case; it is the grouping that changes.
- B. A result binding uses the output of another query, not the user's choice of grouping.
Question 5
A CRM Analytics consultant receives a new project from a client that wants to implement CRM Analytics. They do not currently have CRM Analytics but want guidance on how to ensure their users have the correct access.
They have 1,000 users with a small team of three people who will build both datasets and dashboards. An additional 15 people should be able to only create dashboards. The remaining users should only be able to view dashboards.
Which recommendation should the consultant give the client?
- A. Create and assign three new Salesforce profiles according to the three types of roles defined.
- B. Create and assign Salesforce permission sets according to the three types of roles defined.
- C. Assign the app permissions “viewer”, “editor”, and “manager” to the three types of roles defined.
Show answer and explanation ▾
Correct answer: B
CRM Analytics access is granted through permission sets tied to the permission set license. One permission set for each role, builders of datasets and dashboards, dashboard creators, and viewers, gives every group exactly the capabilities it needs.
Why the other options are wrong:
- A. Profiles are not how CRM Analytics user permissions are assigned.
- C. Viewer, editor and manager control sharing of an individual app, not what a user is permitted to build.
Question 6
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?
- A. Use a permission set license with two different levels of access.
- B. Configure a permission set license assignment with two different levels of access.
- C. Clone the existing permission set with different system permissions.
Show answer and explanation ▾
Correct answer: A
Both groups are covered by the CRM Analytics permission set license, with two levels of access set up under it: one that lets the trained users create dashboards and one that lets the other team use them.
Why the other options are wrong:
- B. A license assignment on its own gives entitlement but does not define two levels of access.
- C. Cloning one permission set does not by itself provide the license both groups need.
Question 7
A system administrator and a CRM Analytics consultant are working together on deploying a recipe/dataflow and a dataset to another org. Prior to this deployment, a package was deployed with all the custom fields used in the dataflow and dataset.
While running the recipe/dataflow in the target environment, the consultant encounters multiple errors related to these custom fields.
How should this be resolved?
- A. Check whether the consultant has been provided access to these custom fields on the target org.
- B. Check whether the Analytics Integration user has been provided access to these custom fields on the target org.
- C. Check whether the system administrator has been provided access to these custom fields on the target org.
Show answer and explanation ▾
Correct answer: B
Dataflows and recipes extract Salesforce data as the Analytics Integration User. If that user has no field-level access to the custom fields in the target org, the run fails on those fields.
Why the other options are wrong:
- A. The consultant's own field access is not what the dataflow uses to extract data.
- C. The system administrator's field access is not what the dataflow uses to extract data.
Question 8
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. Create two sets of dashboards; one for EMEA, and one for CXOs and VPs while filtering the dashboard on the region.
- B. Create two separate datasets; one for EMEA, and one for CXOs and VPs.
- C. Use a field on the user record like Department/Region, and apply row-level security based on that field.
Show answer and explanation ▾
Correct answer: C
A security predicate on the dataset can compare each row with a field on the user record, such as department or region. One dataset and one dashboard then show EMEA users only EMEA rows and show executives everything.
Why the other options are wrong:
- A. Dashboard filters are not security, and two dashboards double the maintenance.
- B. Two datasets duplicate the data and the maintenance for something a predicate handles.
Question 9
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. Create a second dashboard and move the table to this new dashboard.
- B. Create a second page on the dashboard and move the table to this new page.
- C. Create a Visualforce page and display a list view of the Opportunities on this new page.
Show answer and explanation ▾
Correct answer: B
A dashboard runs the queries for the page being viewed. Moving the slow table to a second page means its query runs only when a user opens that page, so the main page loads faster and the table stays in the same dashboard.
Why the other options are wrong:
- A. A second dashboard splits the experience and is harder to maintain than a page.
- C. A Visualforce list view takes the table out of CRM Analytics and loses its dashboard interactions.
Question 10
After getting approval for the dashboard layout design for a desktop, the CRM Analytics consultant is ready to start the design process for a mobile layout.
Which consideration should the consultant keep in mind?
- A. Create a layout with the property “phone” to show the dashboard on the mobile app similar to creating a layout with the property “dashboard” to show on the desktop for the same dashboard.
- B. A “Tablet” or “Phone” layout-where only minWidth and maxWidth have been set-may be displayed on a desktop if the dashboard is embedded in a small frame, or if the browser window is small.
- C. If no layouts are eligible for the mobile device, an error message will be displayed but the dashboard will still be visible on the desktop without errors.
Show answer and explanation ▾
Correct answer: B
A layout is chosen by matching its selectors to the display. A tablet or phone layout defined only by minimum and maximum width can therefore also be picked on a desktop when the dashboard sits in a small frame or a narrow browser window.
Why the other options are wrong:
- A. Layouts are not selected through a property named phone or dashboard in this way.
- C. A device with no matching layout is not handled by showing an error message.
Question 11
Universal Containers has a well-defined role hierarchy in Salesforce where everyone is assigned to an appropriate node. The accounts within their instance are categorized by their demography.
An individual sales rep should be able to view all accounts that they own. In addition, sales reps should be able to see any accounts where the value of the account demography matches the demography defined on their user record. A user could have more than one demography defined on their user record.
To meet this requirement, the CRM Analytics consultant has set up a security predicate of the existing ‘Account’ dataset as follows:
‘OwnerId’ = = “$User.Id” | | ‘Demography’ in [“$User.Demographic_c”] This, however, does not seem to be working as expected.
What is causing the issue?
- A. The security predicate needs to be updated as ‘OwnerId’ = = “$User.Id” | | ‘Demography’ = “$User.Demographic__c”.
- B. The Sales Rep is not provided access permission on custom field Demographic_c on the User object.
- C. The Analytics Security User is not provided access permission on custom field Demographic__c on the User object.
Show answer and explanation ▾
Correct answer: C
CRM Analytics reads User object fields for security predicates as the Analytics Security User. That user needs read access to the custom Demographic field on the User object, or the predicate cannot be evaluated.
Why the other options are wrong:
- A. Replacing the in operator with an equality test does not support a user with several demographics.
- B. The predicate is evaluated by a system user, so the sales rep's own access to the field is not the cause.
Question 12
A CRM Analytics team plans to enable data sync.
Which limit specific to data sync should the team consider before enabling the feature because it may impact existing jobs?
- A. Maximum number of Full Sync connection mode enabled
- B. Maximum number of objects that can be enabled for data sync
- C. Maximum number of data sync jobs cannot exceed the limit
Show answer and explanation ▾
Correct answer: B
Data sync has a limit on how many objects can be enabled across connections. Existing dataflows that extract many objects can reach that limit once sync is turned on, so it should be checked first.
Why the other options are wrong:
- A. A count of connections in Full Sync mode is not the data sync limit to check here.
- C. A cap on the number of sync jobs is not the limit that affects existing jobs when the feature is enabled.
Question 13
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?
- A. Total number of enabled objects
- B. Salesforce external connector number of synced rows
- C. Storage rows of data
Show answer and explanation ▾
Correct answer: A
The plan enables 25 local objects, 10 database objects, 36 from three orgs and 30 from two orgs, for 101 objects in total. That is one more than the 100 objects that can be enabled for data sync.
Why the other options are wrong:
- B. The estimated rows per object stay within what an external Salesforce connection can sync.
- C. The estimated row volumes do not by themselves exceed the storage row allocation.
Question 14
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. Add up and down arrow next to the KPIs to make it more understandable.
- B. Make the numbers bold to emphasize whether it is won or lost.
- C. Position Alt Texts next to the KPIs to make it more understandable.
Show answer and explanation ▾
Correct answer: A
Accessible design never relies on color alone. An up or down arrow next to each KPI shows won or lost through shape, so users who cannot tell red from green still read the result.
Why the other options are wrong:
- B. Bold text looks the same for won and lost, so it adds no distinction.
- C. Alt text serves screen readers and does not help sighted users who cannot tell the colors apart.
Question 15
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?
- A. An SAQL query with a timeseries statement specifying Account Name as the partition and Y-M-W as the Date Cols
- B. An SAQL query with a timeseries statement specifying Opportunity Name as the partition and Y-M-W as the Date Cols
- C. An SAQL query with a timeseries statement specifying Account Name as the partition and Y-M-D as the Date Cols
Show answer and explanation ▾
Correct answer: C
A forecast per customer needs the timeseries statement partitioned by Account Name. The dateCols parameter accepts year-month-day, which gives the granularity needed for a weekly view, and it does not accept a year-month-week combination.
Why the other options are wrong:
- A. Y-M-W is not a valid date column combination for the timeseries statement.
- B. Partitioning by Opportunity Name forecasts per opportunity, not per customer.
Question 16
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?
- A. Add the system permission “Manage Analytics Custom Maps” to the permission set used.
- B. Upload the GeoJSON via the API because it is NOT a function in the UI.
- C. Enable “Custom maps with GeoJSON” in the analytics settings.
Show answer and explanation ▾
Correct answer: A
Uploading custom GeoJSON for map charts is controlled by a user permission. Adding the Manage Analytics Custom Maps system permission to the consultant's permission set makes the upload available in the user interface.
Why the other options are wrong:
- B. Custom GeoJSON can be uploaded in the user interface once the user has the permission.
- C. The upload is controlled by a user permission, not by an analytics setting with that name.
Question 17
Universal Containers (UC) builds three Einstein Discovery models in Salesforce to predict and maximize its revenue per customer. The models are for every region UC has a business: EMEA, AMER, and APAC.
How should a consultant help UC deploy the three Einstein models to Salesforce?
- A. Deploy the same model to all accounts and use an Apex trigger to segment the prediction.
- B. Filter the account data per region and deploy the same model to all segments.
- C. Segment the account data per region and deploy the appropriate model for each segment.
Show answer and explanation ▾
Correct answer: C
One prediction definition can hold several models, each with a segment filter. Segmenting accounts by region and assigning the EMEA, AMER and APAC models to their segments scores every account with the model built for its region.
Why the other options are wrong:
- A. Deploying one model everywhere ignores the two other regional models, and an Apex trigger is not needed.
- B. Deploying the same model to every segment defeats the purpose of building three regional models.
Question 18
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”?
- A. In the currency that is set on the “currency” attribute.
- B. In the connected user’s currency
- C. In the integration user’s currency
Show answer and explanation ▾
Correct answer: C
Dataflows and recipes extract Salesforce data as the Integration User. In a multi-currency org, currency fields such as Amount are loaded into the dataset in that user's currency.
Why the other options are wrong:
- A. The values are not loaded in a currency taken from a currency attribute.
- B. The currency of the user viewing the data does not change the stored Amount values.
Question 19
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?
- A. Use the recipe node “delete” and set “userID” as the deletion ID.
- B. Use the “update” transformation and utilize the “filter” node.
- C. Use the combination of recipe transformations: “join” and “filter”.
Show answer and explanation ▾
Correct answer: C
Recipes have no delete operation, so rows are removed by filtering. Joining Dataset A to Dataset B on userID marks the activities whose user appears in Dataset B, and a filter then keeps only the rows without a match.
Why the other options are wrong:
- A. Recipes have no delete node.
- B. An update transformation changes column values and does not remove rows.
That was 19 of 60.
The full Salesforce CRM Analytics and Einstein Discovery Consultant pack has all 60 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. $39.00 USD, paid once, with free monthly updates and a pass-or-your-money-back guarantee.
Get the full packNot ready yet? Get the first 23 free as one PDF by email. Get the Half Pack →
About the CRM Analytics and Einstein Discovery Consultant exam
These 19 Salesforce CRM Analytics and Einstein Discovery Consultant questions are free here. The free PDF has 23, free by email.
They are drawn from the same bank as the full CRM Analytics and Einstein Discovery Consultant pack, which has 60 questions in total.