Tableau-Desktop-Found Practice Test 3 — 30 Questions

Question 1

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?

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

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 2

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 3

A logistics analyst wants to highlight orders whose shipping cost exceeds a fixed threshold of 500. The analyst creates a calculated field returning a Boolean result and drags it onto the Color shelf, but the resulting legend shows only 'True' and 'False' labels with generic colors. The analyst needs a two-color scheme where qualifying orders are red and all others are gray. Which approach best accomplishes this in Tableau Desktop?

Accepted Answer

Right-click the Boolean field on Color and select 'Edit Colors', then assign red to True and gray to False.. Placing a discrete Boolean field on the Color shelf generates a two-member legend. Using 'Edit Colors' on that field allows explicit assignment of red to True and gray to False, giving the exact two-color encoding requested. This keeps all orders visible while visually distinguishing those above the threshold, and it avoids altering the calculation or splitting the analysis across multiple worksheets.

Answer

Drag the Boolean field to the Filters shelf and set it to True, which automatically colors matching marks red.

Answer

Create a separate worksheet for qualifying orders and another for the rest, then place both in a dashboard.

Answer

Convert the Boolean field to a continuous measure, then choose the red-gray diverging palette.

Question 4

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 5

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.

Question 6

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 7

A marketing analyst builds a scatter plot of Ad Spend against Revenue by Region and wants to highlight the relationship between the two measures on the same view. The analyst drops a continuous Profit measure onto the Color shelf. Which statement describes how Tableau renders the marks?

Accepted Answer

Tableau creates a continuous color legend with a gradient, mapping the range of Profit values to a smooth transition between colors.. A continuous measure on the Color shelf generates a continuous color legend with a gradient, shading each mark according to its position in the measure's range. Discrete dimensions on Color produce swatch legends instead, so the distinction between dimension and measure roles drives which legend style appears.

Answer

Tableau ignores the Profit field on the Color shelf because scatter plots can only encode two measures, one on each axis.

Answer

Tableau creates a discrete color legend with one swatch per distinct Profit value, assigning a separate color to each unique profit amount.

Answer

Tableau converts Profit into a dimension automatically so that each region receives a single solid color based on its profit category.

Question 8

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 9

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 10

You have a dataset with columns 'Date', 'Region', 'Sales', and 'Profit'. You need to reshape the data so that 'Sales' and 'Profit' are in a single column called 'Measure Name' and their values are in a 'Measure Value' column. Which TWO steps should you take?

Accepted Answer

Select 'Sales' and 'Profit' columns in the Data Source tab.. To convert wide data into long format, use the Pivot function in the Data Source tab. Selecting the columns and applying the pivot operation creates the necessary long-form structure. This is critical for creating charts that compare multiple measures effectively, as it allows Tableau to treat 'Sales' and 'Profit' as values within a single categorical dimension.

Answer

Create a calculated field to join the columns.

Answer

Drag 'Measure Names' to the filter shelf.

Answer

Use the Split function on the 'Date' column.

Question 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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.