Last Updated On : 18-Oct-2026
Salesforce Certified Tableau Data Analyst Practice Test
Prepare with our free Salesforce Certified Tableau Data Analyst sample questions and pass with confidence. Our Salesforce-Tableau-Data-Analyst practice test is designed to help you succeed on exam day.
Salesforce 2026
What is a key benefit of using parameter actions in Tableau?
A. They allow users to turn parameters into filters on the dashboard.
B. They create a static view of the data without any interactivity.
C. They restrict user interaction to predefined filters.
D. They allow users to dynamically change calculated fields based on selections.
Explanation:
The correct answer is D. They allow users to dynamically change calculated fields based on selections. Parameter actions are a type of dashboard interaction introduced in Tableau 2019.2 that allow users to update the value of a parameter by interacting directly with marks in a view — such as clicking, hovering, or selecting data points. Because parameters can be referenced inside calculated fields, this interaction dynamically changes the results of those calculations. For example, clicking a region on a map can update a parameter that drives a calculated field, instantly updating a chart, title, or filter across the dashboard. This makes option D the correct answer.
Why the other options are incorrect:
A. They allow users to turn parameters into filters on the dashboard – While parameters can be used within filters, this is not the key benefit of parameter actions. Parameter actions are specifically about driving interactivity through calculations, not simply converting parameters into filters.
B. They create a static view of the data without any interactivity – This is the opposite of what parameter actions do. Parameter actions are inherently interactive and are designed to enhance user engagement with the dashboard, not remove it.
C. They restrict user interaction to predefined filters – Parameter actions do not restrict interaction; they expand it by allowing users to control parameters directly through selections in the view. Restricting interaction is not a benefit or purpose of parameter actions.
Reference:
Tableau Desktop Specialist and Tableau Data Analyst content areas on Dashboard Actions — specifically parameter actions, using selections in a view to update parameter values, and leveraging parameters within calculated fields to create dynamic, interactive dashboards.
When using the INCLUDE Level of Detail (LOD) calculation, where should the dimension referenced by the INCLUDE function be located on the sheet?
A. Not in the View
B. Marks Card
C. Rows or Columns Shelf
D. Filters Shelf
Explanation
The correct answer is A. Not in the View. The INCLUDE Level of Detail (LOD) expression is used to add a dimension to the calculation's level of detail that is not already present in the view. When the specified dimension is not on the Rows shelf, Columns shelf, or Marks card, the INCLUDE keyword ensures that the aggregate is computed at a finer granularity that includes that dimension. Tableau then aggregates the result back up to the level of the view, which can produce different values than a standard aggregate. If the dimension referenced by the INCLUDE function were already in the view, the LOD expression would have no additional effect and would behave like a regular aggregate. This makes option A the correct answer.
Why the other options are incorrect:
B. Marks Card
– If the dimension is on the Marks card (such as Detail, Color, or Size), it is already part of the view's level of detail. In that case, the INCLUDE function would not add any new granularity, and the calculation would not produce the intended effect.
C. Rows or Columns Shelf
– Placing the dimension on the Rows or Columns shelf makes it part of the view's level of detail. The INCLUDE function is specifically designed for dimensions that are not already in the view, so this placement would defeat its purpose.
D. Filters Shelf
– A dimension placed on the Filters shelf affects which data is included in the view, but it does not define the level of detail for aggregation. The INCLUDE function is concerned with dimensions used in the calculation, not filter criteria.
Reference:
Tableau Desktop Specialist and Tableau Data Analyst content areas on Level of Detail (LOD) Expressions — specifically the INCLUDE keyword, its purpose of adding dimensions to the calculation's level of detail that are not present in the view, and the interaction between LOD calculations and the view's dimensions.
What is required to publish a data source to Tableau Server or Tableau Cloud from Tableau Desktop?
A. A Creator site role
B. Administrator permissions on the server
C. A Tableau Public account
D. View permissions on the project
Explanation:
The correct answer is A. A Creator site role. To publish a data source to Tableau Server or Tableau Cloud from Tableau Desktop, the user must have a Creator site role (or be a Server Administrator). The Creator role includes the "Publish" capability, which allows users to publish data sources and workbooks to projects on the server. Without this role or the specific Publish permission granted through a custom role, the user cannot upload data sources from Tableau Desktop. This makes option A the correct answer.
Why the other options are incorrect:
B. Administrator permissions on the server
– While a Server Administrator can publish data sources, Administrator permissions are not required. A Creator site role is sufficient. Requiring full administrator access would be excessive and is not the minimum requirement.
C. A Tableau Public account
– Tableau Public is a separate, free platform for publicly sharing visualizations. It is not used to publish private data sources to Tableau Server or Tableau Cloud, and a Tableau Public account is not required or relevant for this task.
D. View permissions on the project
– View permissions allow a user to see content within a project but do not grant the ability to publish new data sources. To publish, the user needs Publish permissions on the project (typically granted through the Creator site role).
Reference:
Tableau Desktop Specialist and Tableau Data Analyst content areas on Publishing and Sharing — specifically publishing data sources to Tableau Server or Tableau Cloud, the Creator site role, and the Publish capability required to upload content.
A Data Analyst applied a dimension filter to a worksheet with FIXED Level of Detail (LOD) calculations. How does this filter affect the worksheet?
A. The dimension filter alters the data displayed in the worksheet along with the FIXED LOD calculation.
B. The dimension filter alters the data displayed in the worksheet but does not influence the FIXED LOD calculation.
C. The dimension filter is carried out first before computing the FIXED LOD calculation.
D. The dimension filter alters the data displayed in the worksheet before computing the FIXED LOD calculation.
Explanation
The correct answer is B. The dimension filter alters the data displayed in the worksheet but does not influence the FIXED LOD calculation. In Tableau, the order of operations for Level of Detail (LOD) expressions is critical. FIXED LOD calculations are computed before dimension filters are applied. This means that a FIXED LOD expression uses all the data in the underlying data source (or the context filter, if one exists) to compute its aggregate, regardless of any dimension filters placed on the view. The dimension filter is then applied afterward, affecting only the rows displayed in the worksheet, not the value returned by the FIXED LOD calculation. This makes option B the correct answer.
Why the other options are incorrect:
A. The dimension filter alters the data displayed in the worksheet along with the FIXED LOD calculation
– This is incorrect because dimension filters do not affect the results of FIXED LOD calculations. FIXED LODs are computed at their specified level of detail before dimension filters are applied, so the calculated values remain unchanged.
C. The dimension filter is carried out first before computing the FIXED LOD calculation
– This is the opposite of how Tableau's order of operations works. FIXED LOD calculations are processed before dimension filters, not after.
D. The dimension filter alters the data displayed in the worksheet before computing the FIXED LOD calculation
– This incorrectly implies that dimension filters influence the FIXED LOD computation. They do not. Only context filters, data source filters, and extract filters are applied before FIXED LOD calculations.
Reference:
Tableau Desktop Specialist and Tableau Data Analyst content areas on Level of Detail (LOD) Expressions — specifically the order of operations in Tableau, the distinction between FIXED LOD calculations and dimension filters, and how FIXED LODs are computed before dimension filters are applied.
during the creation process. What is the advantage of using a relationship?
A. The join keys are not predetermined and can change with user interactions.
B. The data is saved in an aggregated format to increase the performance for the user.
C. The join type is dynamic and selected when querying the data.
D. All data is merged into one virtual table to enable easier access to important measures.
Explanation
The correct answer is C. The join type is dynamic and selected when querying the data. In Tableau, a relationship is a flexible way to combine multiple tables without physically merging them. Unlike traditional joins that require a predetermined join type (inner, left, right, full outer), relationships defer the join type until the query is executed. Tableau automatically selects the appropriate join type based on the dimensions and measures placed in the view, as well as any filters applied. This dynamic behavior simplifies data modeling, prevents data duplication, and ensures accurate aggregation at the correct level of detail. This makes option C the correct answer.
Why the other options are incorrect:
A. The join keys are not predetermined and can change with user interactions
– Join keys in a relationship are defined during the creation process and remain fixed. While relationships allow multiple tables to be related on matching fields, the keys themselves do not change based on user interactions. Only the join type is determined dynamically at query time.
B. The data is saved in an aggregated format to increase the performance for the user
– Relationships do not store data in an aggregated format. Tableau retains the full granularity of the data and aggregates on the fly based on the view's level of detail. While relationships can improve performance by avoiding unnecessary joins, they do not pre-aggregate the data.
D. All data is merged into one virtual table to enable easier access to important measures
– This describes a traditional join, where tables are merged into a single flat table. Relationships, by contrast, keep tables logically separate and only combine them at query time based on the fields used in the view. This avoids the data duplication and incorrect aggregation issues that can occur with physical joins.
Reference:
Tableau Desktop Specialist and Tableau Data Analyst content areas on Data Modeling — specifically the use of relationships versus joins, the dynamic selection of join types at query time, and the advantages of logical data models for accurate and flexible analysis.
| Salesforce-Tableau-Data-Analyst Exam Questions - Home | Previous |
| Page 3 out of 43 Pages |