View Full Tableau TDA-C01 Exam Dumps and Practice Test Dumps

 

Question 121.

An analyst wants to show sales for the top 10 customers within a selected Region rather than the top 10 customers across the entire data source. What should the analyst do?

1. Add the Region filter to context before applying the Top 10 Customer filter
   2. Convert Customer Name to a measure
   3. Apply the Top 10 filter before adding Region anywhere in the workbook
   4. Use a highlight action instead of filtering

Correct Answer: 1

Explanation:

Tableau’s order of operations determines how different filters interact. A standard Top N dimension filter may be evaluated before an ordinary dimension filter, which can cause Tableau to determine the top customers across the broader dataset rather than within the selected Region. Adding Region to context creates a filtered subset first. The Top 10 Customer filter is then evaluated against that context, returning the top customers specifically within the selected region. Context filters are therefore useful when one filter must establish the dataset on which another filter operates. They should be used deliberately because they can also influence workbook performance and the behavior of other calculations.

Question 122.

Which Tableau filter generally operates after context filters but before measure filters?

1. Table calculation filter
   2. Dimension filter
   3. Forecast filter
   4. Reference line filter

Correct Answer: 2

Explanation:

In Tableau’s general order of operations, context filters are evaluated before standard dimension filters. Measure filters are applied later because they operate on aggregated measure values after the dimensional grouping has been established. This ordering is important in analyses involving Top N filters, FIXED LOD calculations, and aggregated measures. For example, turning a dimension filter into a context filter can change the data that a later dimension filter considers. Table calculation filters operate much later, after table calculations have been computed. Understanding these stages helps analysts diagnose cases where a filter appears to produce unexpected results even though the filter conditions themselves seem correct.

Question 123.

An analyst wants to calculate total Sales for each Customer before any ordinary dimension filters are applied, while still allowing context filters to affect the result. Which calculation is most appropriate?

1. Running Total
   2. INCLUDE LOD
   3. { FIXED [Customer ID] : SUM([Sales]) }
   4. WINDOW_SUM(SUM([Sales]))

Correct Answer: 3

Explanation:

A FIXED level-of-detail expression computes its result at the dimensions explicitly specified in the expression rather than simply following the view’s current dimensionality. FIXED LOD expressions are evaluated after context filters but before ordinary dimension filters in Tableau’s order of operations. Therefore, { FIXED [Customer ID] : SUM([Sales]) } can calculate customer-level sales totals that remain independent of many dimensions and ordinary filters later added to the view. INCLUDE and table calculations are evaluated differently. This behavior makes FIXED calculations especially useful when analysts need a stable denominator, customer lifetime metric, or entity-level total that should not automatically change with ordinary worksheet filtering.

Question 124.

Which Tableau LOD expression is best when an analyst wants to calculate customer-level Sales even though Customer is not displayed in the visualization?

1. EXCLUDE
   2. FIXED only
   3. Table calculation
   4. INCLUDE

Correct Answer: 4

Explanation:

An INCLUDE LOD expression adds a specified dimension to the level of detail used for the calculation even when that dimension is not present in the visualization. For example, { INCLUDE [Customer ID] : SUM([Sales]) } can calculate values at the Customer level and then aggregate those results back to the broader level displayed in the view. This is useful for metrics such as average customer sales by Region when Customer itself is not visible. EXCLUDE removes a dimension from the calculation, whereas FIXED explicitly defines a calculation level that is more independent of the view. INCLUDE is specifically designed to introduce finer granularity into a calculation.

Question 125.

An analyst displays Category and Sub-Category but wants a calculation that returns total Sales for the Category, ignoring Sub-Category. Which approach is most appropriate?

1. Use an EXCLUDE LOD expression that excludes Sub-Category
   2. Create a bin from Sub-Category
   3. Convert Sales to a dimension
   4. Apply a table calculation filter

Correct Answer: 1

Explanation:

EXCLUDE LOD expressions remove selected dimensions from the level of detail used by a calculation. If both Category and Sub-Category are visible, an expression such as { EXCLUDE [Sub-Category] : SUM([Sales]) } calculates Sales at the broader Category level while still allowing Sub-Category marks to remain displayed. This makes it useful for comparisons between a detailed value and its parent-level total. Bins are designed for numeric ranges and do not change calculation granularity. Converting Sales to a dimension would alter its analytical role, and a table calculation filter would affect displayed marks rather than defining the desired aggregation level.

Question 126.

A worksheet shows Sales by Month. Which table calculation would display the cumulative Sales amount through each month?

1. Percent Difference
   2. Running Total
   3. Rank
   4. Percent of Total

Correct Answer: 2

Explanation:

Running Total accumulates the measure as Tableau moves through the marks according to the calculation’s addressing direction. If Month is ordered chronologically, applying Running Total to SUM(Sales) produces cumulative sales through each month. This is useful for year-to-date analysis, goal tracking, and cumulative growth visualizations. The Compute Using setting should be checked because it determines whether Tableau calculates across months, categories, or another dimension in the view. Percent Difference measures change relative to another mark, Rank orders values, and Percent of Total measures contribution to a total. For cumulative progression over time, Running Total is the appropriate quick table calculation.

Question 127.

Which Tableau table calculation should an analyst use to show the percentage increase or decrease in Sales compared with the previous month?

1. Running Total
   2. Rank
   3. Percent Difference
   4. Percent of Total

Correct Answer: 3

Explanation:

Percent Difference compares the current value with another value, commonly the immediately previous mark, and expresses the change as a percentage. In a monthly Sales chart, this can show month-over-month growth or decline. The analyst should ensure that the calculation is addressed across Month in chronological order so the comparison is made against the correct previous period. Running Total accumulates values rather than showing period-to-period change. Rank orders marks based on magnitude, and Percent of Total expresses each mark’s contribution to a total. For relative change between consecutive months, Percent Difference is the most appropriate table calculation.

Question 128.

An analyst wants to rank Sub-Categories by SUM(Sales), with the highest-selling Sub-Category receiving rank 1. Which feature is appropriate?

1. Group
   2. Bin
   3. Context filter
   4. Rank table calculation

Correct Answer: 4

Explanation:

A Rank table calculation assigns a position to each mark based on the value of an aggregated measure. Applying Rank to SUM(Sales) can give the highest-selling Sub-Category rank 1, the next highest rank 2, and so forth. The result depends on how Tableau partitions and addresses the calculation, so the analyst should verify the Compute Using setting, particularly if Category or Region is also present. Groups combine dimension members, bins create numeric ranges, and context filters affect filter order. Ranking displayed aggregate results is a classic table-calculation use case and provides dynamic ordering as the underlying values or filters change.

Question 129.

Which Tableau table calculation returns the sequential position of a mark within its current partition, independent of the mark’s measure value?

1. INDEX()
   2. RANK()
   3. SIZE()
   4. LOOKUP()

Correct Answer: 1

Explanation:

INDEX() returns the sequential position of a mark within a table-calculation partition, beginning with 1. Unlike RANK(), INDEX does not determine position based on the magnitude of a measure. Instead, it reflects the ordering of marks in the current view. This makes INDEX useful for row numbering, advanced filtering, pagination-style logic, and certain custom table calculations. The result can change when the view’s sort order or Compute Using configuration changes. SIZE() returns the total number of marks in the partition, while LOOKUP() retrieves a value from another mark at a specified relative offset. INDEX is therefore specifically associated with positional numbering.

Question 130.

Which Tableau table-calculation function can retrieve the value of an expression from a previous or next row in the current partition?

1. SIZE()
   2. LOOKUP()
   3. INDEX()
   4. WINDOW_MAX()

Correct Answer: 2

Explanation:

LOOKUP() returns the value of an expression from a row at a specified relative offset within the table-calculation partition. For example, LOOKUP(SUM([Sales]), -1) can return the previous mark’s sales value when the view is addressed appropriately. This makes it useful for custom period-over-period calculations, comparisons, and identifying changes between adjacent marks. INDEX returns a mark’s sequential position, while SIZE returns the total number of marks in the partition. WINDOW_MAX evaluates the maximum value across a defined window. Because LOOKUP accesses a different row relative to the current mark, it is particularly useful for previous-period and next-period calculations.

Question 131.

Which Tableau table-calculation function returns the sum of values across a specified window of marks?

1. WINDOW_SUM()
   2. SUM() only
   3. RANK()
   4. ATTR()

Correct Answer: 1

Explanation:

WINDOW_SUM() calculates the sum of an expression across a defined set of marks in the current partition. The window can include the entire partition or a specific range relative to the current mark. For example, it can be used to calculate a moving total or to build a customized denominator for percentage calculations. Unlike ordinary SUM(), which aggregates underlying data according to the view’s level of detail, WINDOW_SUM operates on the aggregated marks already present in the visualization. This distinction is important because table calculations are evaluated later in Tableau’s processing sequence and depend on the layout, addressing, and partitioning of the view.

Question 132.

Which Tableau feature should an analyst use to display an overall average Sales line across a bar chart?

1. Forecast
   2. Trend line
   3. Bin
   4. Reference line

Correct Answer: 4

Explanation:

A reference line can display a benchmark such as an average, median, constant, or parameter-controlled value on an axis-based visualization. Adding an average reference line to a Sales bar chart lets viewers quickly determine which categories are above or below the overall benchmark. The analyst can control whether the reference line applies to the entire table, each pane, or each cell depending on the chart structure. A trend line models relationships or trends, while forecasting projects future values. Bins group numeric values into intervals. When a single benchmark should be visually overlaid on a chart, a reference line is the appropriate Tableau analytics object.

Question 133.

An analyst wants to display an acceptable Sales range between $80,000 and $120,000 as a shaded area in a chart. What should be added?

1. Reference band
   2. Trend line
   3. Hierarchy
   4. Set

Correct Answer: 1

Explanation:

A reference band displays a shaded region between two values on an axis, making it appropriate for showing an acceptable or expected range. In this example, the analyst can define the lower boundary at $80,000 and the upper boundary at $120,000. Viewers can then immediately see which marks fall below, inside, or above the target range. Reference lines display a single value rather than a bounded area. Trend lines model patterns in data, while hierarchies and sets serve entirely different analytical purposes. Reference bands are particularly useful for tolerance limits, service-level ranges, performance zones, and expected operating intervals.

Question 134.

Which visualization is generally most appropriate for comparing one quantitative measure across several discrete categories when precise comparisons are important?

1. Pie chart
   2. Bar chart
   3. Packed bubbles
   4. Treemap

Correct Answer: 2

Explanation:

Bar charts use length along a common baseline, which allows viewers to compare values accurately across categories. They are therefore generally preferable to pie charts, packed bubbles, or treemaps when precise categorical comparisons are important. Sorting the bars can further improve interpretation by making high and low values obvious. Pie charts rely on angle and area, which are harder to compare precisely, while packed bubbles and treemaps are better for high-level magnitude or composition. Bar charts remain one of Tableau’s most effective general-purpose visualization types because they are simple, familiar, and perceptually accurate for categorical comparisons.

Question 135.

A view contains hundreds of categories. The analyst wants to focus on the 10 categories with the highest SUM(Profit). Which Tableau feature should be used?

1. Parameter only
   2. Geographic role
   3. Top N dimension filter
   4. Pages shelf

Correct Answer: 3

Explanation:

A Top N dimension filter can keep only a specified number of members based on an aggregated measure. The analyst can configure the Category field to display the top 10 members by SUM(Profit). Unlike sorting alone, which simply changes order, a Top N filter removes lower-ranked categories from the displayed result. This reduces clutter and helps viewers focus on the strongest performers. Tableau’s order of operations should be considered when other dimension filters are involved because the Top N calculation may need a context filter to produce results within a desired subset. Parameters can make N dynamic, but they do not perform the filtering by themselves.

Question 136.

An analyst wants dashboard users to choose whether a chart displays Sales, Profit, or Quantity without creating three separate worksheets. Which solution is most appropriate?

1. Create three extracts
   2. Create three context filters
   3. Use three separate data sources
   4. Use a parameter with a calculated field that returns the selected measure

Correct Answer: 4

Explanation:

A parameter can present options such as Sales, Profit, and Quantity to the user. A calculated field can then evaluate the selected parameter value and return the appropriate measure. The visualization uses that single calculated field, allowing the same worksheet to switch dynamically between measures. This approach reduces workbook complexity and makes the dashboard more flexible. Separate extracts, context filters, or data sources would add unnecessary complexity and would not directly provide a clean metric-switching mechanism. Parameter-driven measure selection is a common Tableau design pattern for interactive dashboards and can also be combined with dynamic titles so viewers always know which metric is currently displayed.

Question 137.

Which dashboard action should an analyst configure when clicking a customer mark should update a parameter containing that Customer ID?

1. Parameter action
   2. Highlight action
   3. URL action
   4. Filter action

Correct Answer: 1

Explanation:

A parameter action updates a Tableau parameter using a value from a selected mark. If Customer ID is used as the source field, clicking a customer can write that identifier into the parameter. Calculated fields, titles, reference lines, and other logic that depend on the parameter can then respond to the user’s selection. A filter action restricts target worksheet data, while a highlight action emphasizes related marks. URL actions open external resources. Parameter actions are particularly valuable when the selection should influence calculations rather than simply filter data and can support highly interactive, application-like Tableau dashboard experiences.

Question 138.

Which dashboard action should be used when selecting a mark should change which dimension members are IN or OUT of an existing Tableau set?

1. Filter action
   2. Set action
   3. URL action
   4. Highlight action

Correct Answer: 2

Explanation:

A set action changes the membership of a Tableau set based on user interaction with marks. For example, selecting several customers can place those customers into a set and allow calculated fields to compare the selected customers with everyone else. This supports interactive cohort analysis, proportional brushing, custom highlighting, and IN-versus-OUT comparisons. A filter action removes unrelated marks from target views, whereas a highlight action simply emphasizes related marks. URL actions navigate to external resources. Set actions provide more analytical flexibility because set membership can be used throughout calculations and visual encodings rather than merely controlling which rows remain visible.

Question 139.

Which dashboard action is best when selecting a Region should emphasize corresponding marks in other worksheets but leave all other marks visible?

1. Filter action
   2. Parameter action
   3. Highlight action
   4. URL action

Correct Answer: 3

Explanation:

A highlight action emphasizes marks related to a user’s selection while keeping the complete target view visible. This allows the viewer to maintain context while focusing attention on the selected Region. A filter action would instead remove unrelated marks from the target worksheet, which would change the displayed dataset. Parameter actions update parameters, and URL actions open external pages or resources. Highlight actions are particularly useful when the analytical task involves comparison, because users can see both the selected data and the surrounding population simultaneously. This can make patterns and differences easier to understand than filtering everything else from the view.

Question 140.

A user selects an Order ID in a dashboard and should be taken to that order’s page in an external web application. Which Tableau feature is most appropriate?

1. Set action
   2. Parameter action
   3. Filter action
   4. URL action

Correct Answer: 4

Explanation:

A URL action allows Tableau to open an external web address in response to user interaction. The URL can include values from the selected mark, such as Order ID, allowing Tableau to construct a context-specific link to the corresponding record in another application. This can connect Tableau dashboards with CRM systems, support portals, inventory tools, or other internal web applications. Set actions modify set membership, parameter actions update parameter values, and filter actions restrict data in target worksheets. When the required interaction involves navigating from Tableau to an external web resource using data from the selected mark, a URL action is the appropriate choice.