Tableau-Desktop-Found Practice Test 8 — 10 Questions

Question 1

Refer to the exhibit. You are trying to show a 'Grand Total' on a bar chart that uses an aggregate calculation. Why might this be failing?

Accepted Answer

The measure is a non-additive calculation, such as a ratio or distinct count.. Grand totals operate by re-calculating the sum at a higher level of aggregation. If the measure is a non-additive aggregate (like a ratio or a distinct count), Tableau cannot perform a simple sum of the displayed values to reach the total. You must ensure that the total is calculated by aggregating the underlying base data rather than the derived values displayed in the view.

Answer

The visualization uses a dual axis, which disables the Grand Total option.

Answer

The data source has a circular reference in the relationship model.

Answer

The 'Grand Total' feature is only available for crosstab visualizations.

Question 2

Refer to the exhibit. What is the primary purpose of this configuration policy in the Tableau environment?

Accepted Answer

To filter data dynamically based on user identity. This exhibit demonstrates the implementation of Row-Level Security (RLS) using a mapping policy. In a corporate environment, this is critical for compliance and data integrity. By ensuring that users can only view data corresponding to their specific region, organizations prevent data leakage and maintain security standards. Understanding how this mapping interacts with the data model ensures that dashboards remain secure even when shared across large teams.

Answer

To increase dashboard rendering speed

Answer

To automate the creation of new user accounts

Answer

To cache data for multiple users in a shared view

Question 3

Refer to the exhibit. What is the effect of the calculation on the visualization?

Accepted Answer

It computes a 4-month rolling average. The calculation creates a 4-month rolling average (current month plus the 3 previous months). By using a window calculation, Tableau looks at the result set currently in the view and performs an average on that subset. This is a common requirement for smoothing out seasonality in sales data, enabling analysts to identify long-term growth trends rather than being distracted by monthly volatility.

Answer

It calculates the average of all months

Answer

It calculates the average for the current year

Answer

It is a row-level calculation

Question 4

You have a single data source connected to a SQL database. You want to see the total sum of sales for each region. Where should you drag the 'Region' and 'Sales' fields?

Accepted Answer

Drag 'Region' to the Rows shelf and 'Sales' to the Text mark.. To see the total sum of sales for each region, you must place 'Region' on a shelf to create the visual headers (rows or columns) and 'Sales' on the marks card (text or label) to display the aggregated metric. This foundational movement of fields is the core mechanism of Tableau's drag-and-drop interface, which automatically aggregates measures based on the dimensions provided.

Answer

Drag 'Region' to the Filters shelf and 'Sales' to the Pages shelf.

Answer

Drag 'Region' to the Detail mark and 'Sales' to the Rows shelf.

Answer

Drag both fields to the Filters shelf.

Question 5

When creating a scatter plot, what is the impact of placing a dimension on the Detail mark?

Accepted Answer

It creates a separate mark for every member of the dimension.. Placing a dimension on the Detail mark increases the granularity of the view by creating a separate mark for each member of that dimension. In a scatter plot, where you are already mapping two measures to axes, this allows for the comparison of specific categories or items (like customers or products) without cluttering the view with headers, enabling effective visual identification of outliers and clusters.

Answer

It adds a new axis to the chart.

Answer

It automatically color-codes the marks.

Answer

It hides the labels for all data points.

Question 6

When creating a scatter plot to analyze the relationship between two measures, how can you add a third dimension to the view without creating a new chart?

Accepted Answer

Drop the dimension onto the Color mark.. Scatter plots are highly effective for visualizing correlations between two measures. By dragging a dimension onto the Color or Shape card, you add a third variable, allowing for immediate visual clustering and pattern identification. This technique transforms a simple bivariate plot into a multi-dimensional analysis tool, enabling deeper insights into how specific categories behave relative to the two primary numerical metrics being plotted on the axes.

Answer

Add the dimension to the Filters shelf.

Answer

Move the dimension to the Row shelf.

Answer

Place the dimension on the Pages shelf.

Question 7

You have a dataset where each row represents a student's final grade in a class. You want to calculate the average grade per department, but you discover that the data is at the individual student level. What is the most efficient way to prepare this for your view?

Accepted Answer

Use the default aggregation 'Average' within the view.. Tableau's aggregation capabilities allow you to perform calculations like averages at any level of detail without needing to pre-aggregate the data. By simply dragging the 'Grade' measure onto the view and selecting the 'Average' aggregation, Tableau handles the math dynamically. This is the most efficient approach because it maintains the granularity of the underlying data for further exploration or drill-downs.

Answer

Create a new table in the source database containing averages.

Answer

Use the 'Group' function to combine student grades.

Answer

Use an LOD expression to fix the average for each student.

Question 8

You notice a field in your Data pane has a small '=' sign icon next to its name. What does this signify in Tableau?

Accepted Answer

The field is a custom calculation. The '=' symbol indicates that the field is a calculated field. This is a critical indicator because it signals to the user that the value is derived from a formula rather than being a raw field from the underlying data source. Knowing this helps analysts quickly debug logic, understand data lineage, and ensure that the calculations are correctly implemented for the current analytical requirements.

Answer

The field is a geographic dimension

Answer

The field is a parameter

Answer

The field is a primary key

Question 9

When designing a high-performance dashboard in Tableau Desktop, an analyst creates a calculated field that aggregates correctly at the view level. What distinguishes a measure from a dimension in the Tableau data pane?

Accepted Answer

Measures represent quantitative numerical data that can be aggregated, while dimensions contain categorical attributes for slicing data.. Measures represent quantitative numerical data that can be aggregated mathematically, whereas dimensions contain qualitative categorical values used to slice, dice, and categorize the visual layout. Understanding this fundamental distinction ensures correct pill coloring, proper default aggregation behavior, and accurate axis generation throughout the dashboard development lifecycle.

Answer

Measures are always discrete green pills that generate distinct headers, while dimensions are continuous blue pills that form axes.

Answer

Measures contain qualitative categorical information used to group data, whereas dimensions store numerical metrics for aggregation.

Answer

Measures can only be used as column headers, whereas dimensions are strictly restricted to row headers in tabular views.

Question 10

A user wants to understand the difference between dimensions and measures in Tableau. Which statement accurately describes a dimension?

Accepted Answer

Dimensions affect the level of detail in a view by creating headers.. Dimensions contain qualitative values such as names, dates, or geographical data. They are used to categorize, segment, and reveal details in the data. Understanding this distinction is fundamental because dimensions determine the level of detail in a visualization. When dragged into the view, dimensions typically add headers or split the visualization, whereas measures aggregate data by default. Mastering this concept is critical for building accurate data models and effective analytical views.

Answer

Dimensions are always numerical values that can be mathematically aggregated.

Answer

Dimensions are automatically aggregated when added to the visualization.

Answer

Dimensions are only supported for data sources that use a live connection.