TABLEAU-CRM Sample Questions

TABLEAU-CRM Sample Questions & Answers

Data extraction, dataflows and the CRM Analytics API take the top share, alongside dataset and user security, lens visualizations and bindings, dashboard requirements and UX design, change management, and interpreting Einstein Discovery stories.

Launch the full TABLEAU-CRM simulator →

Showing 10 of 20 free samples.

  1. Question 1Intermediate

    Administration · Performance Optimization

    A sales performance dashboard is experiencing slow load times. A consultant's analysis reveals that the underlying dataset contains over 100 columns from the Opportunity object, but the dashboard only uses 15 of them. The dataflow that creates this dataset is complex, with multiple joins and transformations. What is the most effective first step to improve the dashboard's performance?

    Show answer & explanation

    Correct answer: B

    The most direct and effective solution is to reduce the width of the dataset. An unnecessarily wide dataset increases storage and query processing time. Using a sliceDataset (or Remove Fields in a recipe) to keep only the required 15 columns will create a much more efficient dataset, leading to faster query performance and dashboard load times.

  2. Question 2Intermediate

    Data Layer · Dataflow Optimization

    A consultant is reviewing a dataflow that combines Account, Opportunity, and Case data. The current design is inefficient, causing the dataflow to run slowly. The consultant wants to propose an optimized structure.

    Which of the following dataflow structures represents the most optimized approach for this scenario?

    flowchart TD subgraph Option A acc1[sfdcDigest Account] --> aug1[augment w/ Opps] aug1 --> aug2[augment w/ Cases] aug2 --> reg1[sfdcRegister] end subgraph Option B acc2[sfdcDigest Account] opp2[sfdcDigest Opps] case2[sfdcDigest Cases] acc2 & opp2 & case2 --> reg2[sfdcRegister] end subgraph Option C opp3[sfdcDigest Opps] case3[sfdcDigest Cases] opp3 --> aug3[augment w/ Accounts] case3 --> aug4[augment w/ Accounts] aug3 & aug4 --> union1[union] union1 --> reg3[sfdcRegister] end subgraph Option D acc4[sfdcDigest Account] --> reg4[sfdcRegister] opp4[sfdcDigest Opps] --> reg5[sfdcRegister] case4[sfdcDigest Cases] --> reg6[sfdcRegister] end

    Show answer & explanation

    Correct answer: C

    Option C is the most performant design, known as the 'star schema' or 'lookup' pattern. By augmenting the 'fact' datasets (Opps, Cases) with the 'dimension' dataset (Accounts) in parallel, the dataflow avoids creating overly wide and sparse intermediate datasets that chained augments (Option A) can produce. This parallel processing is more efficient and scalable.

  3. Question 3Intermediate

    CRM Analytics Dashboard Implementation · SAQL Functions

    A consultant is writing a SAQL query to analyze sales trends over time. They need to generate a series of date values to ensure there are no gaps in their monthly analysis, even if no sales occurred in a particular month. The SAQL statement is:

    q = ____(start='2023-01-01', end='2023-12-31', unit='month');

    Which SAQL function should be used in the blank to generate the required date stream?

    Show answer & explanation

    Correct answer: C

    The fill statement is specifically designed to generate rows for missing date values in a dataset. While the timeseries function also works with dates, fill is the correct function for creating a continuous stream of date records based on a start, end, and time unit, which can then be used to ensure no gaps exist in a time-based analysis.

  4. Question 4Advanced

    Security · Security Predicate Behavior

    A consultant has implemented row-level security on an Opportunity dataset using a security predicate: 'OwnerId' == "$User.Id". Sharing inheritance is NOT enabled. A Sales Manager, who is not the owner of any opportunities but is above the owners in the role hierarchy, needs to see all opportunities belonging to their direct reports. How will the security predicate affect the Sales Manager's view of the data?

    Show answer & explanation

    Correct answer: B

    Security predicates are absolute filters based on the user running the query. They do not automatically respect the Salesforce role hierarchy. Since the manager is not the direct owner of any opportunities, the condition 'OwnerId' == "$User.Id" will evaluate to false for all records, and they will see an empty dataset.

  5. Question 5Intermediate

    Einstein Discovery Story Design · Interpreting Story Results

    After running an Einstein Discovery story to predict customer churn, a consultant presents the results to stakeholders. A stakeholder points to the 'Top Predictive Factors' card and asks, "This says Contract Type is the most important factor. Does this mean changing the contract type will prevent churn?" What is the most accurate response for the consultant to provide?

    Show answer & explanation

    Correct answer: B

    This is the most critical concept in interpreting predictive models. Einstein Discovery identifies statistical correlations, not necessarily causal relationships. While Contract Type is a strong predictor, it might be a proxy for other unmeasured factors (e.g., customer size, service level). It's crucial to explain that correlation does not imply causation.

  6. Question 6AdvancedSelect 2

    Data Layer · Data Ingestion Limits

    A marketing team wants to upload a CSV file containing campaign influence data into CRM Analytics. The file is 750 MB and contains 12 million rows. They plan to do this on a weekly basis. What are the limitations of the standard CSV upload feature in Data Manager that the consultant should make them aware of? (Select TWO)

    Show answer & explanation

    Correct answers: A, B

    The standard UI-based CSV upload feature has a file size limit, which is typically around 500 MB. A 750 MB file would exceed this limit and fail to upload.

    The standard CSV upload feature in the Data Manager UI does not support scheduling. For recurring uploads, a more robust and automated solution like using an external connector or an ETL tool is required.

  7. Question 7Intermediate

    CRM Analytics Dashboard Design · Chart Selection

    A business analyst needs to visualize the contribution of different product categories to total quarterly sales. They also want to see how the total sales amount has trended over the last four quarters. Which combination of charts would be most effective for displaying these two specific insights on a dashboard?

    Show answer & explanation

    Correct answer: C

    A donut chart (or pie chart) is ideal for showing part-to-whole relationships, making it perfect for visualizing the contribution of each product category to the total. A timeline chart (or line chart) is the standard and most effective way to display a trend over a continuous time period like quarters.

  8. Question 8Beginner

    Administration · Extended Metadata (XMD)

    A consultant needs to change the display format of a measure field in a dataset from a raw number (e.g., 2500000) to a currency format (e.g., $2.5M) across all lenses and dashboards that use this dataset. They also want to change the field's API name to be more descriptive. Which CRM Analytics feature should be used to make these global changes?

    Show answer & explanation

    Correct answer: B

    The Extended Metadata (XMD) file controls the formatting and display properties of fields within a dataset. By editing the XMD, a consultant can define number formats, change labels (not the API name itself, but the display label), and set colors that will be applied by default everywhere the dataset field is used, ensuring consistency.

  9. Question 9Advanced

    CRM Analytics Dashboard Implementation · Bindings

    A consultant has built a dashboard with three charts: 'Sales by Region' (Chart A), 'Sales by Product' (Chart B), and 'Top 10 Accounts' (Chart C). The requirement is that when a user clicks a Region in Chart A, both Chart B and Chart C should filter to show data only for that selected region. How should this interactivity be configured using bindings?

    Show answer & explanation

    Correct answer: C

    While this can be achieved with complex selection bindings, the simplest and most efficient method is faceting. As long as all three widgets (steps) are based on the same dataset (or connected datasets), enabling faceting will automatically apply selections from one widget as filters to the others. This is the standard mechanism for this type of interactivity.

  10. Question 10Intermediate

    Einstein Discovery Story Design · Data Preparation

    While preparing data for an Einstein Discovery story to predict deal closure, a consultant discovers two fields, Annual_Revenue and NumberOfEmployees, that have a very high correlation coefficient (0.92). What is the best practice for handling these two variables before creating the story?

    Show answer & explanation

    Correct answer: B

    The high correlation indicates multicollinearity, where two or more predictor variables are highly related. Including both can distort the model's interpretation of their individual importance. The best practice is to remove one of the variables or, even better, combine them into a single, more meaningful feature (like a size score). This reduces redundancy and often leads to a more stable and interpretable model.

Ready for the real thing?

The full TABLEAU-CRM simulator has every exam-style question, timed mode, and instant scoring.

Go to the TABLEAU-CRM simulator →