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

Question 1

A financial analyst is building a view that shows the cumulative year-to-date (YTD) sales for each product category. The analyst wants the calculation to be computed at the correct level of detail and to work when the view is filtered by region. Which two statements accurately describe how Tableau handles table calculations and filters in this scenario? (Choose two.)

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

Accepted Answer

Table calculations are computed after dimension filters, so a region filter will affect the YTD values.. Table calculations are computed after dimension filters, so a region filter will restrict the data and affect YTD values. Also, table calculations have a scope (e.g., Table, Pane) that determines how the calculation is computed across dimensions. Both statements correctly describe how Tableau processes table calculations in the context of YTD sales by category.

Answer

Table calculations cannot be used with filters because they are computed on the underlying data source.

Answer

Table calculations ignore the level of detail and always aggregate at the highest level, so YTD will be the same for all categories.

Answer

Table calculations are computed before dimension filters, so a region filter will not affect the YTD values.

Question 2

A data analyst is working with a data source that contains a field 'Order Date' (Date type) and 'Sales' (Measure). The analyst wants to create a view that shows the cumulative running total of sales over time, with the running total resetting at the beginning of each year. Which approach should the analyst use?

Accepted Answer

Create a calculated field using the RUNNING_SUM function and place it on a view with continuous dates, then use the 'Add Table Calculation' dialog to set the running total to restart every year.. The RUNNING_SUM table calculation, when configured to restart every year, provides a cumulative total that resets at each year boundary. This is done by editing the table calculation's 'Compute Using' settings to include a restart based on the year of the order date. This approach correctly handles the annual reset and is the standard method in Tableau for such requirements.

Answer

Create a calculated field using the formula SUM([Sales]) and then use the 'Add Table Calculation' dialog to set it as a running total with a restart every year.

Answer

Use the 'Quick Table Calculation' option on the Sales measure and select 'Running Total', then manually edit the table calculation to restart every year by adding a partition on the year of the order date.

Answer

Create a calculated field using the WINDOW_SUM function with a partition by year, and place it on the view with discrete dates.

Question 3

A financial analyst has a view showing 'Profit' by 'Sub-Category' as a bar chart. The analyst wants to highlight only the sub-categories that have a profit greater than $10,000 by coloring those bars in green and all others in gray. Which feature should the analyst use to achieve this?

Accepted Answer

Create a calculated field that returns 'Green' for profit > 10000 and 'Gray' otherwise, then place this field on the Color shelf.. A calculated field that returns specific color names based on a logical condition provides exact control over bar colors. By placing this field on the Color shelf, Tableau assigns the specified colors to each bar according to whether its profit exceeds $10,000. This method is simple, dynamic, and ensures the correct bars are highlighted as required.

Answer

Create a set on 'Sub-Category' where profit > 10000, then place the set on the Color shelf and assign green to 'In' and gray to 'Out'.

Answer

Drag 'Profit' to the Color shelf and set a custom diverging color palette with a threshold at $10,000.

Answer

Use the 'Highlight' feature by selecting the bars with profit > 10000 and choosing a green highlight color.

Question 4

A financial analyst is building a view with 'Region' on Rows and monthly revenue on Columns. The analyst applies a table calculation on revenue that computes a running total. After adding a filter that excludes one region, the running totals for the remaining regions change unexpectedly. The analyst wants the running total computed only across the regions that remain after filtering. Which Tableau behavior explains this and what should the analyst do?

Accepted Answer

The filter is a dimension filter that alters the data before the table calculation; converting it to a context filter or using a table calculation filter will produce the desired result.. Tableau's order of operations determines when filters and table calculations execute. A regular dimension filter can be applied before a table calculation, changing the set of marks the running total accumulates over. Converting the region filter to a context filter forces it to run first, so the running total is computed only across the regions that remain. This gives the analyst the intended cumulative values.

Answer

The running total is a measure, so it cannot be filtered; the analyst must rebuild the calculation as a LOD expression.

Answer

Table calculations are computed after filters on dimensions, so the running total already excludes filtered regions; the analyst should verify the calculation's addressing.

Answer

Dimension filters are applied before table calculations, so the running total reacts to the filter; no change is needed.

Question 5

A financial analyst has a view showing 'Segment' on Rows and 'Profit Ratio' on Columns as a bar chart. She wants to add a reference line that shows the overall average profit ratio across all segments, and she wants that line to remain at the same position even if she later filters the view to show only a subset of segments. Which reference line scope should she choose?

Accepted Answer

Table. Reference lines support Per Pane, Per Cell, and Table scopes. Table scope computes the line using all marks in the view, so a single average profit ratio line is drawn across every segment. Per Pane and Per Cell would recompute the value within each pane or cell, changing the line's position, and no scope computes across every row of the data source regardless of the view.

Answer

Entire Table (All Rows in Data Source)

Answer

Per Cell

Answer

Per Pane

Question 6

A hospital analyst builds a view that shows Readmission Rate by Department. The workbook connects to a live SQL Server data source, and the analyst wants readers of the published dashboard to see the most current readmission figures each time they open it, without the analyst manually refreshing anything. Which connection strategy satisfies this requirement?

Accepted Answer

Keep the data source as a live connection so that every time the view is rendered, Tableau queries the underlying database and returns current values.. A live connection queries the source database each time a view is rendered, so readers automatically see current readmission rates without a manual refresh step. Extract-based approaches store a snapshot whose values remain fixed until refreshed, which does not satisfy a requirement for automatically current figures.

Answer

Publish the workbook with the live connection and configure the data source to refresh on a scheduled basis in Tableau Server or Tableau Cloud.

Answer

Embed the readmission values as a static text object on the dashboard and update that text object whenever the underlying database changes.

Answer

Create a full extract of the data source and let readers manually select Refresh from the Data menu whenever they want updated figures.

Question 7

A data analyst is exploring a dataset and wants to understand the distribution of sales across different product categories. The analyst decides to create a histogram of sales. Which two statements are true regarding histograms in Tableau? (Choose two.)

Accepted Answer

The count of records in each bin is typically represented by the CNT() function or the Number of Records field.. Histograms in Tableau are constructed by binning a continuous measure to create intervals, then counting the number of records in each bin. The bin size is user-defined, not automatically optimized. The count of records is typically represented by CNT() or the Number of Records field. These two statements accurately describe the process and components of a histogram in Tableau.

Answer

Histograms in Tableau require the use of a calculated field to define the bins.

Answer

A histogram can be created by placing a continuous measure on Columns and a count of records on Rows, without creating bins.

Answer

The bin size in a histogram is automatically optimized by Tableau based on the data distribution.

Question 8

A data analyst is preparing a Tableau extract for a dashboard that will be published to Tableau Cloud. The source is a large relational table with many columns, and the analyst wants to reduce extract size and improve performance while preserving the ability to add new fields later. Which two actions should the analyst take when configuring the extract? (Choose two.)

Accepted Answer

Use 'Hide Unused Fields' to remove fields not used in any worksheet before creating the extract.. Reducing extract size and improving performance comes from limiting both columns and rows. Hiding unused fields removes columns that no worksheet references, and an extract filter restricts rows to the relevant date range. Together they shrink the extract and speed up queries. Converting measures to dimensions or changing refresh strategy does not reduce storage and can harm analysis.

Answer

Set the extract to 'Incremental Refresh' and schedule it hourly to keep the file small.

Answer

Convert all measures to dimensions to reduce the extract's storage footprint.

Answer

Enable 'Assume Referential Integrity' to speed up extract creation.

Question 9

A healthcare analyst builds a view with 'Department' on Rows and 'Average Length of Stay' on Columns. She wants to display a small horizontal bar inside each row that shows the department's value relative to the maximum value in the view, without adding a second axis or changing the mark type. Which Marks card property should she configure?

Accepted Answer

Bar (in-cell bar). The in-cell bar mark type draws a proportional bar within each cell based on the value relative to the maximum in the view. It does not require a second axis and keeps the existing row layout, so it directly satisfies the requirement. Size, Text, and Tooltip change thickness, labels, or hover content respectively, and none of them renders a persistent relative bar in each row.

Answer

Tooltip

Answer

Text

Answer

Size

Question 10

A retail analyst builds a view with 'Region' on Rows and 'Sales' on Columns as a bar chart, then adds 'Category' to the Color shelf. She wants to add a table calculation that ranks regions by sales within each category, and she wants the ranking to update correctly when the view is filtered to a subset of regions. Which two actions should she take? (Choose two.)

Accepted Answer

Set the 'Compute Using' option for the table calculation to 'Category'.. Ranking regions within each category requires a table calculation such as RANK_DENSE on the aggregated sales measure, plus a Compute Using setting that partitions the calculation by Category. Together these produce a view-responsive rank that recalculates when filters change. Converting Sales to discrete, duplicating Region on Detail, or using a FIXED level of detail expression all fail to deliver the desired within-category, filter-responsive ranking.

Answer

Convert the 'Sales' measure to a discrete dimension so the ranking is computed row by row.

Answer

Use a Level of Detail expression with FIXED to compute the rank independently of the view's filters.

Answer

Add 'Region' to the Detail shelf so the table calculation has more marks to evaluate.

Question 11

An analyst builds a view showing Sales by Region using a live connection to a massive enterprise data warehouse. The dashboard feels sluggish during filtering. Which architectural component processes the query generation and executes the heavy lifting in this live connection setup?

Accepted Answer

The connected database management system executes the query and returns aggregated result sets to Tableau.. In a live connection scenario, Tableau acts as the query generator that translates user actions into native database queries. The underlying database engine performs the heavy aggregation and data processing. Understanding this distinction is crucial for optimizing dashboard performance because bottlenecks often stem from database tuning rather than Tableau client configurations when working with live enterprise sources.

Answer

The Tableau Data Engine processes the query natively in memory before sending requests to the database backend.

Answer

The VizQL Server translates visual specifications into database execution plans and caches the returned result sets.

Answer

The Backgrounder service intercepts the dashboard filters and streams pre-calculated data blocks asynchronously.

Question 12

A user needs to understand the core difference between a live connection and an extract in Tableau. Which scenario best dictates the use of an extract?

Accepted Answer

When you need to perform complex calculations on a large dataset without impacting database performance.. Extracts are snapshots of data that improve performance for large datasets by moving the processing load from the source database to the local Tableau engine. Choosing between live and extract connections is a foundational skill for optimizing dashboard responsiveness. Understanding this distinction ensures that users balance the need for real-time data accuracy with the necessity of maintaining a performant, stable user experience during high-concurrency reporting scenarios.

Answer

When the underlying data source requires real-time updates every second.

Answer

When the data source is a small, static CSV file with no performance issues.

Answer

When you want to ensure that security permissions are applied directly at the database level for every view.

Question 13

What is the primary function of a 'Set' in Tableau?

Accepted Answer

To create a custom group of data points based on defined criteria.. Sets are a powerful tool for dynamic grouping and segmentation. They allow users to create custom segments based on specific conditions or manual selections and then use these segments as a field in the analysis. Mastering sets allows for deeper 'in vs. out' analysis, which is essential for comparing subsets of data against the whole, providing insights that simple filtering cannot easily achieve.

Answer

To change the connection type of a data source.

Answer

To automatically join two separate data tables.

Answer

To format the axis of a bar chart.

Question 14

Why would you use a 'Group' instead of a 'Set' when preparing data in Tableau?

Accepted Answer

To combine multiple dimension members into a single, fixed category.. Groups are used to combine existing dimension members into higher-level categories, while Sets are used for conditional membership. Knowing when to use one versus the other is vital for building robust data models. Groups allow for a fixed, static hierarchy that is useful for simplifying complex data, whereas Sets provide dynamic and conditional logic that adapts as the underlying data changes over time.

Answer

To create a dynamic category that updates based on a calculation.

Answer

To perform a spatial join between two geographic files.

Answer

To filter the dataset based on an 'in/out' condition.

Question 15

Which TWO of the following are benefits of using parameters in Tableau?

Accepted Answer

They allow for dynamic 'what-if' analysis in visualizations.. Parameters allow users to dynamically change parts of a workbook, such as thresholds, top-N filters, or measures, without modifying the underlying data source. Mastering parameters elevates a dashboard from static to highly interactive. They are essential for creating 'what-if' analyses and allowing end-users to customize their view, which is a core requirement for high-impact analytical tools that support complex decision-making processes.

Answer

They allow users to change the underlying data source connection type.

Answer

They automatically refresh the data from the database.

Answer

They can be used to permanently delete data from the server.