Tableau-Desktop-Found Understanding Tableau Concepts Practice Test 4 — 15 Questions

Question 1

An analyst creates a calculated field using a FIXED level of detail expression to calculate regional sales totals. When a standard dimension filter is applied to the worksheet, the fixed calculation does not change. Why does this occur in Tableau?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Standard dimension filters execute after fixed level of detail expressions in the Tableau order of operations.. Fixed level of detail expressions compute values at the specified dimensions without regard for the view's layout or standard dimension filters because fixed expressions sit higher in Tableau's order of operations than dimension filters. This architectural design allows analysts to calculate cohort metrics and overall benchmarks that remain immune to standard user filtering within the worksheet view.

Answer

Fixed LOD expressions are permanently hardcoded into the data source schema during the initial connection phase.

Answer

Fixed LOD calculations automatically convert all measures into discrete dimensions upon initial compilation.

Answer

The analyst forgot to add the region field to the Marks card as a detail attribute before applying the filter.

Question 2

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.

Question 3

Which TWO of the following statements correctly describe the behavior of the 'Data Interpreter' in Tableau?

Accepted Answer

It can identify and remove extra headers from Excel files.. Data Interpreter is a powerful tool for cleaning messy spreadsheets before analysis. It identifies sub-tables, removes headers, and cleans up formatting issues automatically. Understanding when to use it saves significant time during data preparation. This knowledge is essential for Tableau practitioners, as it prevents errors stemming from poorly structured raw data and ensures that downstream calculations are performed on clean, properly formatted, and reliable data sets.

Answer

It automatically joins multiple data sources into a single logical model.

Answer

It permanently alters the original source file on the user's hard drive.

Answer

It is only available for data sources connected via a live connection.

Question 4

Which of the following actions is the most efficient way to change the default aggregation of a measure?

Accepted Answer

Right-click the measure in the Data pane and select Default Properties > Aggregation.. Changing the default aggregation at the field level is a best practice that ensures consistency across all future visualizations using that field. It avoids the need to manually change the aggregation every time a measure is dropped onto a shelf. This efficiency improves workflow speed and minimizes the risk of human error, which is critical when maintaining large dashboards where standardized metric definitions are required for stakeholders.

Answer

Create a new calculated field for every visualization that uses the measure.

Answer

Update the data source file directly to include a new aggregated column.

Answer

Drag the measure to the Marks card and manually select the aggregation each time.

Question 5

A retail analyst drags the discrete numeric field 'Order Year' onto the Columns shelf and 'Category' onto the Rows shelf, then places a continuous 'Profit' measure on Text. The resulting view displays a compact text table with year columns and category rows. They now want each year to be read as an independent header across the top rather than a single continuous axis. Which Tableau concept explains why the view already renders as discrete headers, and what would change if the field were made continuous?

Accepted Answer

The field is blue because it is discrete, producing separate column headers; switching it to continuous would create a single axis with a continuous range along the top.. In Tableau, discrete fields are blue and generate separate headers or panes, while continuous fields are green and generate a single axis. Because the view shows distinct year columns, the year field is discrete. Changing that field to continuous would replace the separate headers with one axis scaled across the range of years, altering both layout and how marks are positioned.

Answer

The field is blue because it is a dimension, and every dimension placed on Columns automatically produces a continuous axis rather than separate headers.

Answer

The field is green because it is a measure, and any measure placed on Columns always renders as discrete headers regardless of its role.

Answer

The field is green because it is continuous, and converting it to discrete would replace the headers with a single axis that spans the entire data range.

Question 6

A marketing analyst connects Tableau Desktop to a cloud-based CRM and wants every new opportunity record added by the sales team to appear in the workbook when the view is refreshed, without manually rebuilding the data source. Which connection type should the analyst use?

Accepted Answer

A live connection to the CRM. A live connection queries the source system whenever the view is rendered, so records added after the workbook was authored appear without rebuilding the data source. Extract-based approaches, joins to static files, and publishing settings change performance, storage, or governance but do not deliver automatic visibility of newly created records in the same way.

Answer

A cross-database join to a local spreadsheet

Answer

An extract refreshed on a schedule

Answer

A published data source with a stored password

Question 7

A sales operations analyst has a view showing SUM(Sales) by Region. They want to see each region's sales as a percentage of total sales across all regions, displayed as a bar chart where the bars sum to 100 percent. Which Tableau feature should they use?

Accepted Answer

Quick Table Calculation of Percent of Total on SUM(Sales). Percent of Total is a table calculation that expresses each mark as a portion of the total across the addressed scope. Because the analyst wants regional shares that sum to one hundred percent on a bar chart, applying this quick table calculation to SUM(Sales) is the direct approach, while dual axes, manual expressions, and mark changes do not produce the same proportional encoding.

Answer

A calculated field using SUM(Sales) / TOTAL(SUM(Sales))

Answer

Changing the mark type to Pie and using Angle as the size

Answer

A dual axis combining SUM(Sales) and a reference line at the average

Question 8

A financial analyst builds a view showing Profit Ratio by Sub-Category. To highlight only sub-categories whose Profit Ratio is below zero, the analyst creates a calculated field returning a boolean based on Profit Ratio < 0 and places it on the Color shelf. Which Tableau concept does this calculated field represent when used on Color?

Accepted Answer

A discrete dimension that splits marks into true and false categories. A boolean calculated field acts as a discrete dimension, so placing it on Color separates marks into two labeled groups. Because the expression evaluates Profit Ratio against zero, only sub-categories meeting the condition are colored distinctly. Sets and parameters are related concepts but are separate features, and continuous gradients require a measure rather than a two-value boolean.

Answer

A parameter that the viewer can toggle on the dashboard

Answer

A continuous measure that produces a color gradient

Answer

A set defined by a condition on Profit Ratio

Question 9

A logistics analyst wants to show shipment counts by destination city on a map, but several cities share the same name across different states. The data includes City, State, and Country fields but no latitude or longitude. Which approach best ensures Tableau plots each city correctly?

Accepted Answer

Assign the City field a geographic role and add State and Country to the Detail shelf so Tableau resolves the ambiguity. Tableau geocodes place names automatically when a geographic role is assigned, but ambiguous names require additional geographic context. Adding State and Country to the Detail shelf supplies that context so each city is matched to the correct location. Density marks, measure conversion, and dual axes change visual or aggregation behavior without resolving the underlying geographic ambiguity.

Answer

Change the mark type to Density so overlapping cities are combined into a single shaded region

Answer

Use a dual axis with latitude on one axis and longitude on the other

Answer

Convert the City field to a measure so Tableau treats each value numerically

Question 10

A retail analyst is building a dashboard that must show the same sales measure at two different levels of aggregation: total sales per store and total sales per product category, on a single worksheet without blending or joining additional tables. Which two Tableau features allow the measure to be computed at a level of detail independent of the view's dimensions? (Choose two.)

Accepted Answer

A table calculation with a specified addressing and partitioning scope. Level of detail expressions and table calculations both let a measure be evaluated at a granularity that differs from the view's dimensions. FIXED expressions define their own scope inside the calculation, while table calculations operate on returned marks with configurable addressing and partitioning. Parameters, bins, and groups change interactivity or dimension structure but do not independently control aggregation level.

Answer

A parameter used as a filter on the store dimension

Answer

A bin created from the sales measure

Answer

A group combining several product categories

Question 11

A business analyst has a data source containing a field called 'Shipping Cost' that is currently classified as a measure with a default aggregation of SUM. The analyst wants to display the average shipping cost per order on a view without changing the underlying data source. Which action should the analyst take?

Accepted Answer

Drag 'Shipping Cost' to a shelf, then use the drop-down menu on the pill and select Measure > Average.. The correct approach is to change the aggregation of the measure on the view itself. Right-clicking the pill on a shelf and selecting Measure > Average sets the aggregation for that specific worksheet without modifying the data source's default properties. This preserves the original SUM default for other analyses while allowing the analyst to see average shipping cost per order.

Answer

Change the default aggregation of the 'Shipping Cost' field to Average by right-clicking the field in the Data pane and selecting Default Properties > Aggregation > Average.

Answer

Create a calculated field using the formula AVG([Shipping Cost]) and replace the original field on the shelf with this calculation.

Answer

Right-click the 'Shipping Cost' field in the Data pane and select 'Convert to Dimension', then place it on a shelf and set the aggregation to Average.

Question 12

A sales manager is building a view and wants to show the total sales for each region as a bar chart. The 'Region' field is a dimension and 'Sales' is a measure. After dragging 'Region' to Columns and 'Sales' to Rows, the bar chart appears. The manager then drags 'Category' to Color on the Marks card. What is the effect of adding 'Category' to Color?

Accepted Answer

The bars are split into stacked segments representing each category's sales, and the total bar height remains the sum of all categories for that region.. When a dimension is placed on the Color shelf, Tableau uses it to differentiate marks by color. On a bar chart, this results in stacked bars, where each bar represents the total for the primary dimension and is segmented by the color dimension. The total height remains the sum of all segments, but the breakdown by category is visible through color.

Answer

The bars are grouped side-by-side by category within each region, with each category having its own bar.

Answer

The bars are replaced with a scatter plot showing individual category sales points for each region.

Answer

The bars remain unchanged, but a color legend appears that allows filtering by category.

Question 13

A sales operations analyst is building a view showing total profit by product category. After dragging 'Category' to the Rows shelf and 'Profit' to the Columns shelf, the analyst notices the mark type has defaulted to a bar chart and that the Profit axis is continuous. The analyst wants to compare discrete categories against a numeric value. Which statement best describes how Tableau is treating these two fields in this view?

Accepted Answer

'Category' is treated as a discrete dimension and 'Profit' is treated as a continuous measure.. Tableau classifies every field by a role and a type. Qualitative text fields such as 'Category' default to discrete dimensions, generating row headers. Quantitative numeric fields such as 'Profit' default to continuous measures, generating an axis and aggregating with SUM. This combination produces the bar chart the analyst observes and is the standard starting point for comparing categories against numeric values.

Answer

Both 'Category' and 'Profit' are treated as continuous fields, so Tableau builds a line chart.

Answer

'Profit' is treated as a dimension, so Tableau aggregates it into a single header row.

Answer

'Category' is treated as a continuous dimension and 'Profit' is treated as a discrete measure.

Question 14

A marketing analyst connects Tableau Desktop to a Microsoft Excel workbook containing a single sheet of campaign records. She wants to build several visualizations without repeatedly re-importing the file, and she needs the workbook's data to remain available inside the Tableau workbook even when the original .xlsx file is moved to an archive folder. Which connection type should she use?

Accepted Answer

Extract connection. An extract stores a compressed snapshot of the source data inside the Tableau workbook, so the visualizations keep working after the original Excel file is relocated. A live connection, a cross-database join, or a server refresh schedule all depend on the source file remaining reachable, which the scenario explicitly rules out by archiving the .xlsx.

Answer

Live connection to the Excel workbook

Answer

Cross-database join to the Excel workbook

Answer

Publish the workbook to Tableau Server and rely on scheduled refresh

Question 15

A data analyst is building a view that shows the average shipping cost per order across different ship modes. The data source contains one row per order line item, and orders can have multiple line items. The analyst notices that the average shipping cost is skewed because orders with many line items are overrepresented. Which Tableau feature should the analyst use to calculate the average shipping cost per order correctly?

Accepted Answer

Use a Level of Detail (LOD) expression with FIXED to calculate the average per order, then aggregate.. The FIXED LOD expression computes the average shipping cost at the order level, ignoring the line-item granularity. This ensures each order contributes equally to the final average. Other methods either operate at the wrong level of detail or fail to deduplicate orders, leading to skewed results.

Answer

Use a data blend to join the data source to itself on Order ID, then average the shipping cost.

Answer

Use a regular calculated field with SUM([Shipping Cost]) / COUNT([Order ID]) and set the aggregation to Average.

Answer

Use a table calculation to compute the average shipping cost per order, then filter.