Analytics-Con-201 — Salesforce Certified CRM Analytics and Einstein Discovery Consultant

Full question text, answer options, and explanations for this practice set — a spoiler-free alternative is the interactive quiz above for scored, shuffled practice.

1. 1. What is a CRM Analytics App?

   • A. A mobile application for CRM Analytics on iOS and Android
   • B. A container that organizes related dashboards, datasets, lenses, and stories for a specific business function(correct)
   • C. A Salesforce Flow that automates analytics reporting
   • D. An API for querying Salesforce data using SAQL

   Explanation: A CRM Analytics App (formerly Analytics App) is a container that groups related dashboards, datasets, lenses (single-visualization explorations), and Einstein Discovery stories organized around a business domain (e.g., a Sales Analytics App, a Service Analytics App). Apps control access through sharing settings and provide a cohesive analytical experience for a specific team or function.

2. 2. A company wants to use CRM Analytics with data from Salesforce plus external CSV files from their ERP. Which data integration approach should the consultant recommend?

   • A. Export Salesforce data to CSV and combine with ERP CSV in Excel before uploading to CRM Analytics
   • B. Use CRM Analytics Dataflows to pull Salesforce objects AND External Data connectors (or CSV file uploads) to bring in ERP data, combining them within the dataflow(correct)
   • C. Create a Salesforce report that joins Salesforce and ERP data, then connect it to CRM Analytics
   • D. CRM Analytics can only use Salesforce native data; external data requires a separate BI tool

   Explanation: CRM Analytics supports multi-source data integration through Dataflows (which pull Salesforce object data using extractSalesforceData nodes) combined with external data loaded via CSV uploads, connected data sources (Snowflake, S3, BigQuery), or Recipes. A Dataflow can join Salesforce data and previously loaded external datasets using augment or join nodes, creating unified datasets for analysis.

3. 3. A consultant is choosing between a Dataflow and a Recipe for data preparation in CRM Analytics. Which two statements correctly describe when to use each? (Choose 2)

   • A. Recipes provide a visual, no-code UI for data transformation and are preferred for simpler multi-source joins without JSON editing(correct)
   • B. Dataflows are the only option for connecting to external data sources outside Salesforce
   • C. Dataflows are JSON-based transformation pipelines that have been the traditional CRM Analytics ETL mechanism and support complex transformations(correct)
   • D. Recipes cannot join data from multiple Salesforce objects

   Explanation: Recipes provide a drag-and-drop visual interface for data transformation (filtering, joining, aggregation) and support external connections, making them more accessible for non-technical users. Dataflows are JSON-based pipeline definitions that have historically been the primary ETL mechanism in CRM Analytics, supporting complex node-based transformations. Both can connect to external data sources. Recipes can join multiple Salesforce objects using connected data sources.

4. 4. A sales manager wants a CRM Analytics dashboard that automatically shows only the data for deals they own, without manually filtering. What CRM Analytics feature enables this?

   • A. Dashboard-level SAQL WHERE clause filtering
   • B. Row-Level Security (RLS) using security predicates on the dataset(correct)
   • C. A static dashboard filter set to the manager's User ID
   • D. Separate dashboards for each sales manager

   Explanation: Row-Level Security (RLS) in CRM Analytics enforces data visibility at the dataset level using security predicates — filter conditions that dynamically restrict which rows a user sees based on their identity (UserId, Role, custom fields). When a sales manager opens a dashboard, RLS automatically filters the underlying dataset to show only their deals without any manual filtering. This is the scalable, secure approach compared to static filters or separate dashboards per user.

5. 5. What is the maximum number of rows that a CRM Analytics Dataset can contain?

   • A. 1 million rows
   • B. 250 million rows(correct)
   • C. 500 million rows
   • D. Unlimited rows

   Explanation: A CRM Analytics Dataset can contain up to 250 million rows. This is a platform limit that consultants must account for when designing data strategies for high-volume data sources. When data exceeds this limit, strategies include data aggregation (pre-aggregating to reduce row count), date range filtering (loading only recent data), or using Connected Sources that query external databases directly rather than loading all rows into a dataset.

6. 6. A CRM Analytics consultant is assessing whether CRM Analytics or standard Salesforce Reports and Dashboards better fits a client's requirements. Which two scenarios favor CRM Analytics? (Choose 2)

   • A. The client needs to analyze data from Salesforce combined with external sources like Snowflake and S3(correct)
   • B. The client needs a simple list report of all open Opportunities sorted by amount
   • C. The client needs AI-powered predictive insights (win probability, churn risk) embedded in dashboards(correct)
   • D. The client needs a report that shows Contacts with or without Cases (outer join)

   Explanation: CRM Analytics excels at: (1) multi-source analytics that joins Salesforce data with external systems (Snowflake, S3, CSV files); (2) AI/ML-powered insights through Einstein Discovery for predictions and recommendations. Standard Reports handle simple list reports and basic Salesforce-only reporting efficiently without requiring CRM Analytics licenses. Report Types with outer joins are native to standard Reports.

7. 7. In CRM Analytics, what is a Lens?

   • A. A saved filter applied to a dashboard
   • B. A single visualization (chart, table, or metric) created by exploring a dataset(correct)
   • C. A row-level security predicate definition
   • D. A connection configuration for an external data source

   Explanation: A Lens in CRM Analytics is a single saved visualization — a chart, table, compare table, or metric — created by exploring a dataset in the Explorer. Lenses can be added to dashboards as components. They represent a single analytical view of a dataset and can be saved for reuse or embedded in multiple dashboards.

8. 8. A CRM Analytics dashboard needs to allow users to filter all visualizations on the page by a Date Range (e.g., This Quarter, Last Quarter). Which component should the consultant use?

   • A. A List Selector widget connected to a dimension field
   • B. A Date Range Selector widget connected to a date field in the dataset(correct)
   • C. A SAQL formula that calculates the current quarter
   • D. A static filter set at the dashboard level in Dashboard Properties

   Explanation: The Date Range Selector widget in CRM Analytics dashboards allows end users to interactively select date ranges (relative like 'This Quarter' or absolute) and propagates the filter to all connected chart components on the dashboard. This provides dynamic, user-controlled date filtering without requiring dashboard edits. A List Selector is used for dimension/category filtering, not date ranges.

9. 9. A CRM Analytics consultant is building a dashboard that shows pipeline by sales stage. When a user clicks on a bar in the chart, they should be taken to a detailed breakdown page. Which two features enable this drill-down behavior? (Choose 2)

   • A. Configure a Facet binding so the clicked chart filters other charts on the same page(correct)
   • B. Configure a Navigation step binding so clicking a bar navigates to a detail page in the same dashboard(correct)
   • C. Add a hyperlink URL field to the dataset pointing to the detail page
   • D. Use a SAQL subquery to automatically expand detail rows when a bar is clicked

   Explanation: Facet bindings create cross-filtering where clicking a selection in one chart automatically filters other charts on the same dashboard page. Navigation step bindings allow clicking a chart element to navigate to another page within the same dashboard (useful for master-detail drill-down patterns). Hyperlink URL fields can navigate to Salesforce records but don't create dynamic drill-down within the dashboard.

10. 10. A CRM Analytics dashboard needs to show the current user's name as a text label (e.g., 'Hello, John!'). Which mechanism enables this in Dashboard JSON?

    • A. A hardcoded text widget displaying a static name
    • B. A SAQL query that fetches the current user's name from the dataset
    • C. A dynamic text widget using the {{cell}} template with a init SAQL step querying the current user context(correct)
    • D. A Connected App that passes the username as a URL parameter

    Explanation: CRM Analytics dashboards support dynamic text using the {{cell}} template syntax, which allows inserting the result of a SAQL step (query) into a text widget. An init step can query the current user's name using the salesforce_users dataset and inject it into the greeting text. This is the standard approach for personalized dynamic content in CRM Analytics dashboard JSON.

11. 11. What is SAQL in the context of CRM Analytics?

    • A. Salesforce Admin Query Language — used to query Setup metadata
    • B. Salesforce Analytics Query Language — used to query CRM Analytics datasets in dashboards and lenses(correct)
    • C. Salesforce Apex Query Library — used to build Apex-based analytics
    • D. Standard ANSI SQL used to query Salesforce objects

    Explanation: SAQL (Salesforce Analytics Query Language) is CRM Analytics' native query language for analyzing datasets. It is used under the hood in lenses and dashboards and can be written directly in the Dashboard JSON or Explorer for advanced custom queries. SAQL syntax resembles SQL but is purpose-built for multi-dimensional analytics (grouping, projections, ordering) against CRM Analytics datasets, not Salesforce objects directly.

12. 12. A CRM Analytics consultant needs to embed a CRM Analytics dashboard directly in a Salesforce Record page (e.g., on the Account page). Which two options support this? (Choose 2)

    • A. Add the CRM Analytics Dashboard Lightning Component to the Account record page layout using Lightning App Builder(correct)
    • B. Embed the dashboard via an iFrame in a Visualforce page added to the Account layout
    • C. Use the Analytics tab to link to the dashboard URL from the Account record
    • D. Use the Einstein Analytics Dashboard component in Lightning App Builder with filters binding to the record's Account ID(correct)

    Explanation: CRM Analytics dashboards can be embedded in Salesforce record pages using the CRM Analytics Dashboard standard Lightning component added via Lightning App Builder (options A and D describe the same approach with different naming — it is the same Lightning component). The component can be configured to filter the embedded dashboard by the current record's ID, providing contextual analytics. iFrame embedding is a workaround with security and session management issues. Using the Analytics tab requires navigation away from the record.

13. 13. In a CRM Analytics Dataflow, which node type is used to pull data from a Salesforce standard or custom object?

    • A. csvLoad
    • B. extractSalesforceData(correct)
    • C. connectSalesforceData
    • D. importSalesforce

    Explanation: The extractSalesforceData node in CRM Analytics Dataflows is used to extract records from a Salesforce standard or custom object (e.g., Opportunity, Account, Contact__c). It specifies the object API name and the fields to include. The extracted data flows through subsequent nodes (filter, augment, computeExpression, etc.) for transformation before being loaded into a dataset.

14. 14. A CRM Analytics consultant needs to combine Opportunity data with Account data to show the Account's Industry on each Opportunity row. Which Dataflow node performs this lookup join?

    • A. filter
    • B. augment(correct)
    • C. append
    • D. computeExpression

    Explanation: The augment node in CRM Analytics Dataflows performs a left-outer join between two data sources using a key field (e.g., Opportunity.AccountId = Account.Id), adding columns from the right dataset (Account fields) to each row in the left dataset (Opportunity). This is used to enrich a primary dataset with lookup fields from a related dataset — the equivalent of a SOQL relationship query.

15. 15. A Dataflow in CRM Analytics is failing with a 'Dataflow time limit exceeded' error. Which two approaches can help resolve this? (Choose 2)

    • A. Add a filter node early in the dataflow to reduce the number of records being processed(correct)
    • B. Break the single large dataflow into multiple smaller dataflows that run sequentially(correct)
    • C. Increase the Salesforce governor limit for dataflow execution time
    • D. Run the dataflow at midnight when Salesforce servers are less busy

    Explanation: Dataflows have a maximum execution time limit. To resolve timeout issues: (1) Add filter nodes as early as possible in the dataflow to reduce the number of rows being processed through expensive transformation steps; (2) Split a large monolithic dataflow into multiple smaller, focused dataflows that can run in shorter time windows. Salesforce dataflow time limits are platform limits that cannot be increased. Running at midnight does not change execution time limits.

16. 16. A consultant needs to load historical opportunity data from an external CSV file into CRM Analytics as a dataset. What is the recommended method?

    • A. Paste the CSV content directly into a SAQL query
    • B. Upload the CSV file through the External Data API or the CRM Analytics UI ('Create Dataset from CSV')(correct)
    • C. Import the CSV into Salesforce as Opportunity records first, then use a Dataflow to extract them
    • D. Use a Salesforce Report with the CSV data and connect it to CRM Analytics

    Explanation: External data (CSV files) can be loaded into CRM Analytics directly using the External Data API (programmatic upload) or through the CRM Analytics UI using the 'Create Dataset' wizard to upload a CSV file. The CSV's metadata (column names, types) can be defined via a metadata JSON file accompanying the CSV. Importing into Salesforce first adds unnecessary steps and storage. Reports cannot be used as CRM Analytics data sources.

17. 17. A company uses CRM Analytics and wants to connect it directly to their Snowflake data warehouse for live queries without loading data into CRM Analytics datasets. Which feature enables this?

    • A. External Data API
    • B. CRM Analytics Connected Data Source (Live Connection to Snowflake)(correct)
    • C. Dataflow with a csvLoad node pointing to Snowflake exports
    • D. Salesforce Connect OData adapter pointing to Snowflake

    Explanation: CRM Analytics supports Connected Data Sources (also called Live Connections or Direct Data connections) that query external databases like Snowflake, Amazon Redshift, and Google BigQuery directly without loading data into CRM Analytics datasets. Queries are pushed down to the external database for processing. This is ideal for large data warehouses where full data replication is impractical.

18. 18. A CRM Analytics consultant is designing a Recipe to prepare Opportunity data for analysis. Which two transformations are commonly performed in Recipes? (Choose 2)

    • A. Adding a computed column (e.g., Discount % = (List Price - Sales Price) / List Price)(correct)
    • B. Filtering rows to include only Opportunities Closed Won in the last 2 years(correct)
    • C. Deploying the dataset to a Production CRM Analytics org
    • D. Publishing the dashboard to an Experience Cloud site

    Explanation: Recipes in CRM Analytics support data transformation operations including: computed/derived columns (formula-based calculations like discount percentage), filtering rows based on field values and date conditions, joining datasets, and aggregation. Deployment between orgs and Experience Cloud publishing are administrative operations unrelated to Recipes' ETL functionality.

19. 19. What is Einstein Discovery in Salesforce CRM Analytics?

    • A. A search engine for finding records in Salesforce using natural language
    • B. An AI-powered analytics feature that identifies patterns in data, explains why outcomes happen, and suggests improvements(correct)
    • C. A real-time event monitoring system for Salesforce actions
    • D. A machine learning model training platform for custom AI algorithms

    Explanation: Einstein Discovery is an AI/ML-powered analytics feature in CRM Analytics that automatically analyzes data to: identify what factors most influence an outcome (e.g., what drives opportunity wins), explain patterns in historical data, and suggest prescriptive recommendations for improving outcomes. It can surface insights as embedded prediction fields on Salesforce records (e.g., Win Probability on an Opportunity).

20. 20. An Einstein Discovery story analyzes Opportunity win rates. The outcome variable should be:

    • A. The Opportunity Amount (numeric)
    • B. A binary field indicating whether the Opportunity was Won or Lost(correct)
    • C. The Close Date of the Opportunity
    • D. The Sales Rep's name

    Explanation: Einstein Discovery stories analyze a target outcome variable. For win rate analysis, the outcome should be a binary (two-value) field: Won vs. Lost. Einstein Discovery will identify the features (opportunity characteristics) that most strongly predict whether an opportunity is Won. Numeric outcomes (like Amount) would train a regression model. Close Date is a time field, not a win/loss indicator. Sales Rep name is a dimension, not an outcome.

21. 21. After training an Einstein Discovery model for opportunity win prediction, a consultant wants to surface the predictions on live Opportunity records in Salesforce. Which two steps are required? (Choose 2)

    • A. Deploy the Einstein Discovery model from the story to generate a Prediction field on the Opportunity object(correct)
    • B. Create a scheduled Dataflow or Flow to write predictions back to a custom field on Opportunity records
    • C. Add the Einstein Prediction component or the custom prediction field to the Opportunity Lightning page(correct)
    • D. Export the model weights as a CSV and upload them to Salesforce Files

    Explanation: To surface Einstein Discovery predictions on Salesforce records: (1) Deploy the trained model from the story, which creates a scheduled writeback that populates a custom prediction field on the Opportunity object with the predicted score and key influencing factors; (2) Add the Einstein Predictions component (or the custom prediction field) to the Opportunity Lightning record page so users see the prediction inline. Manually writing back via Flow/Dataflow is an alternative but not the standard approach. Exporting model weights is not a Salesforce feature.

22. 22. In Einstein Discovery, what does the 'Prescriptions' section of a story show?

    • A. A list of medications recommended for healthcare-related Salesforce implementations
    • B. Actionable recommendations — specific changes to input variables that would improve the predicted outcome(correct)
    • C. The model accuracy metrics (precision, recall, F1 score)
    • D. A history of all previous Einstein Discovery story runs

    Explanation: The Prescriptions section in Einstein Discovery stories provides actionable, prescriptive recommendations: specific changes to influencing variables that would improve the predicted outcome for each record. For example, for a low-probability Opportunity, prescriptions might suggest: 'Involving a Solution Engineer increases win probability from 23% to 48%.' This moves beyond prediction (what will happen) to prescription (what to do about it).

23. 23. How is access to a CRM Analytics App controlled for different users?

    • A. By assigning CRM Analytics Permission Sets that grant access to specific apps
    • B. By sharing the CRM Analytics App with specific users, groups, or roles using App sharing settings(correct)
    • C. By setting the OWD for CRM Analytics Apps to Private
    • D. By embedding the app in a Salesforce record page with FLS restrictions

    Explanation: CRM Analytics Apps have sharing settings where administrators can control who can view or manage the app. Apps can be shared with individual users, public groups, roles, or the entire org. By default, new apps are private (visible only to the owner and admins). CRM Analytics Permission Sets control platform feature access (ability to use CRM Analytics at all), while App sharing controls which specific apps each user can access.

24. 24. A CRM Analytics dataset contains Opportunity data for all regions. Regional sales managers should only see data for their own region in all dashboards. Which two configurations implement row-level security? (Choose 2)

    • A. Add a Security Predicate to the dataset filtering rows where 'Region' = '{!USERROLE}'(correct)
    • B. Implement inheritance: configure the dataset to inherit Salesforce record-level sharing from the source Opportunity object(correct)
    • C. Create a separate dataset and app for each region
    • D. Set a dashboard-level filter that users cannot change

    Explanation: Row-Level Security in CRM Analytics datasets can be implemented in two ways: (1) Security Predicates — custom filter expressions using user attributes (like Role, custom user fields, or security dataset lookups) that automatically filter dataset rows per user; (2) Salesforce Sharing Inheritance — for datasets built from Salesforce objects, configure the dataset to inherit the Salesforce sharing model, so users only see CRM Analytics rows for records they can see in Salesforce. Creating separate datasets per region is unscalable. Dashboard-level filters can be changed by users and don't enforce data security.

25. 25. A user with the 'CRM Analytics Plus User' permission set is unable to create new CRM Analytics Apps. Which additional permission is most likely missing?

    • A. Manage CRM Analytics
    • B. Create and Edit CRM Analytics Apps(correct)
    • C. Customize Application
    • D. Modify All Data

    Explanation: The ability to create and edit CRM Analytics Apps requires the 'Create and Edit Analytics Apps' permission (part of the CRM Analytics Admin or explicitly granted permission set). The standard 'CRM Analytics Plus User' permission set allows exploring and viewing dashboards but does not automatically include app creation rights. The 'Manage CRM Analytics' permission is a higher-level admin permission. 'Customize Application' and 'Modify All Data' are unrelated Salesforce core permissions.