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

 

Question 161.

An analyst wants to create a view that shows total Sales by Region and then display each Region as a percentage of overall Sales. Which approach is most appropriate?

1. Apply a Percent of Total table calculation to SUM(Sales)
   2. Convert Sales to a dimension
   3. Use a geographic role
   4. Create a bin on Region

Correct Answer: 1

Explanation:

Percent of Total is a table calculation that expresses each mark as a proportion of the total for the current partition. In a view showing Region and SUM(Sales), applying Percent of Total to Sales allows the analyst to see how much each region contributes to overall sales. The Compute Using setting should be checked to ensure the calculation is being performed across Region. Converting Sales to a dimension would change its behavior and prevent normal aggregation. Geographic roles and bins are unrelated to percentage calculations. For a straightforward contribution-to-total analysis, Percent of Total is usually the simplest and most direct Tableau solution.

Question 162.

Which Tableau table calculation is best for displaying the difference between current month Sales and previous month Sales?

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

Correct Answer: 2

Explanation:

The Difference table calculation compares the current mark to another mark, commonly the previous one in the addressing sequence. In a monthly time-series view, applying Difference to SUM(Sales) can show the absolute month-over-month increase or decrease. The analyst must verify that the calculation is addressed across Month and that months are sorted chronologically. Running Total accumulates values over time, Percent of Total shows contribution to a partition, and Rank orders values. Therefore, Difference is the appropriate quick table calculation when the requirement is to show how much the current period changed from the immediately preceding period.

Question 163.

An analyst wants to show the percentage change in Sales from one month to the next. Which table calculation is most appropriate?

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

Correct Answer: 3

Explanation:

Percent Difference compares the current value with another mark, typically the previous mark, and expresses the change as a percentage rather than an absolute amount. This makes it well suited to month-over-month growth analysis. For example, if Sales increase from 100,000 to 120,000, the Percent Difference calculation can show a 20% increase. Difference would show only the absolute increase of 20,000. Running Total accumulates values, while Percent of Total measures contribution to a whole. As with other table calculations, correct addressing and partitioning are essential to ensure Tableau compares each month with the intended previous period.

Question 164.

Which Tableau table calculation should be used to assign a numerical order to products based on SUM(Sales)?

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

Correct Answer: 4

Explanation:

RANK() assigns a ranking to marks based on the value of an expression, such as SUM(Sales). The product with the highest sales can receive rank 1, followed by lower-selling products. The ranking behavior can vary depending on the specific rank function and how ties are handled. Analysts should also verify the Compute Using configuration, especially when ranking separately within categories or regions. INDEX() returns sequential position in the partition rather than value-based rank, SIZE() returns partition size, and LOOKUP() retrieves values from nearby marks. For value-based ordering, RANK is the appropriate table-calculation function.

Question 165.

Which Tableau function returns the sequential position of a mark within its current partition?

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

Correct Answer: 1

Explanation:

INDEX() returns the position of the current mark within a table-calculation partition, starting with 1. Unlike RANK, the result is based on the current ordering of marks rather than their measure values. This makes INDEX useful for row numbering, advanced filtering, or custom display logic. Changing the sort order of the view may change the INDEX values because the positions change. SIZE() returns the number of marks in the partition, while FIRST() returns an offset to the first row. INDEX is therefore the function specifically designed to provide sequential position within the partition.

Question 166.

Which Tableau table calculation function returns the total number of marks in the current partition?

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

Correct Answer: 2

Explanation:

SIZE() returns the total number of marks or rows in the current table-calculation partition. This can be useful in advanced calculations that depend on the number of displayed marks, such as conditional formatting, pagination logic, or calculating relative positions. Because SIZE is a table calculation, its result depends on the partitioning defined by the view. INDEX returns the current mark’s position, LOOKUP retrieves a value at a relative offset, and RANK orders marks according to measure values. When the analyst needs to know how many marks exist in the active partition, SIZE is the correct function.

Question 167.

Which Tableau table-calculation function is most appropriate for retrieving the previous month’s Sales value directly?

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

Correct Answer: 3

Explanation:

LOOKUP() retrieves the value of an expression from another row relative to the current row. For example, LOOKUP(SUM([Sales]), -1) can return the previous month’s Sales when the table calculation is addressed across Month in chronological order. This makes it useful for custom period-over-period comparisons or calculations that need direct access to prior or next values. WINDOW_SUM aggregates across a range of marks, INDEX returns sequential position, and SIZE returns partition size. LOOKUP is therefore the most direct function when the analyst needs to reference a specific neighboring row in the displayed result.

Question 168.

Which Tableau function calculates a sum across a specified range of marks in a table-calculation partition?

1. SUM()
   2. LOOKUP()
   3. RANK()
   4. WINDOW_SUM()

Correct Answer: 4

Explanation:

WINDOW_SUM() computes the sum of an expression across a defined range of marks within the current partition. The analyst can define the window relative to the current mark, such as several marks before and after, or use the entire partition. This enables custom moving totals and rolling calculations. Ordinary SUM aggregates underlying records according to the visualization’s level of detail and is evaluated earlier than table calculations. LOOKUP retrieves a value from a relative position, while RANK assigns an ordering. WINDOW_SUM is therefore the appropriate table-calculation function when a sum must be calculated across a window of already aggregated marks.

Question 169.

An analyst wants to calculate a three-month moving average of Sales. Which Tableau feature is most appropriate?

1. Moving Average table calculation
   2. Data source filter
   3. Group
   4. Bin

Correct Answer: 1

Explanation:

A Moving Average table calculation computes an average over a defined window of marks, making it suitable for smoothing monthly Sales trends. For a three-month moving average, Tableau can average the current month together with the appropriate surrounding or preceding months depending on the configuration. This helps reduce short-term fluctuations and reveals broader trends. The Compute Using setting and window definition should be reviewed carefully to ensure the calculation moves across the Month dimension as intended. Data source filters restrict records, groups combine members, and bins create numeric ranges. Moving Average is the appropriate Tableau feature for rolling mean analysis.

Question 170.

Which Tableau feature should an analyst use to display a constant target value across a chart?

1. Forecast
   2. Reference line
   3. Highlight action
   4. Story point

Correct Answer: 2

Explanation:

A reference line can display a constant target or a statistical benchmark across an axis-based visualization. For example, a line at 500,000 can represent a Sales target, allowing viewers to quickly identify which marks fall above or below it. Tableau also supports reference lines based on averages, medians, parameters, and other values. Forecasts project future values, highlight actions emphasize related marks, and story points organize a sequence of views. When the requirement is to display a benchmark directly on a chart, a reference line provides a clear and flexible solution.

Question 171.

Which Tableau feature should be used to display a shaded acceptable range between two values on an axis?

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

Correct Answer: 3

Explanation:

A reference band displays a shaded area between two values on a continuous axis. It is useful for showing acceptable performance ranges, tolerance zones, expected intervals, or other bounded targets. For example, an analyst could shade the range between 80% and 100% of a target. Marks falling outside that band become visually easy to identify. A reference line represents a single benchmark rather than a range. Trend lines model relationships, and forecasts estimate future values. Sets classify dimension members. For displaying a visual range with lower and upper boundaries, a reference band is the appropriate Tableau analytics feature.

Question 172.

Which Tableau feature is most appropriate for modeling the relationship between Sales and Profit in a scatter plot?

1. Reference line only
   2. Forecast
   3. Parameter
   4. Trend line

Correct Answer: 4

Explanation:

A trend line can be added to a scatter plot to model the general relationship between two quantitative measures. Tableau can estimate whether the relationship is positive, negative, or weak and can provide model-related statistical details. For example, plotting Sales against Profit and adding a trend line can help determine whether higher sales tend to correspond with higher profit. Analysts should remember that a statistical relationship does not prove causation. Forecasting is intended for future time-series values, parameters are user-controlled inputs, and reference lines represent benchmarks. Trend lines are therefore the correct feature for relationship modeling in scatter plots.

Question 173.

Which Tableau analytics feature should an analyst use to estimate future monthly Sales based on historical time-series data?

1. Forecast
   2. Trend line only
   3. Group
   4. Bin

Correct Answer: 1

Explanation:

Forecasting in Tableau uses historical time-series data to estimate future values based on patterns such as level, trend, and seasonality when appropriate. The analyst can display forecasted Sales together with prediction intervals that communicate uncertainty. Forecasting works best when the historical data contains a meaningful time structure and sufficient observations. A trend line models an existing relationship but does not provide the same future time-series projection functionality. Groups and bins organize data rather than predict it. Therefore, Forecast is the appropriate feature when the analytical goal is to project likely future monthly Sales.

Question 174.

An analyst wants to create a filled map showing Profit by State. Which field should typically be placed on Color?

1. State
   2. Profit
   3. Latitude
   4. Longitude

Correct Answer: 2

Explanation:

In a filled map, the geographic field such as State defines the geographic areas, while a measure such as Profit can be placed on Color to encode magnitude or direction. Tableau shades each state according to the Profit values associated with it. Latitude and Longitude are used internally or explicitly for positioning, but they do not represent the business metric that controls shading in this case. If Profit contains positive and negative values, a diverging palette may be useful to distinguish gains and losses. Therefore, Profit should be placed on Color to communicate state-level performance visually.

Question 175.

Which Tableau visualization is generally best when an analyst wants to show one circle per city, with circle size representing Sales?

1. Symbol map
   2. Filled map
   3. Histogram
   4. Text table

Correct Answer: 1

Explanation:

A symbol map places marks at geographic locations such as cities and can encode measures through mark size or color. If circle size represents Sales, viewers can quickly compare relative sales magnitude across different cities. A filled map colors geographic polygons and is more appropriate for states, countries, or other areas with defined boundaries. Histograms show distributions, and text tables display exact values. Symbol maps work particularly well for point-like geographic entities and allow multiple visual encodings to be combined. Therefore, a symbol map is the most suitable choice when each city should appear as a separate sized mark.

Question 176.

Which Tableau feature allows users to drill from Year to Quarter to Month in a date field?

1. Set
   2. Group
   3. Bin
   4. Date hierarchy

Correct Answer: 4

Explanation:

Tableau automatically provides a hierarchy for many date fields, allowing users to drill from broader units such as Year into Quarter, Month, and more detailed levels. This makes it easy to explore time-series data at different granularities without constructing separate fields manually. Hierarchies provide plus and minus controls in the visualization so users can expand and collapse levels. Sets define subsets, groups combine members, and bins organize numeric ranges. For structured temporal drill-down from Year to Quarter to Month, a date hierarchy is the appropriate Tableau mechanism.

Question 177.

Which Tableau feature is best for combining several product categories into a custom business category?

1. Group
   2. Set
   3. Parameter
   4. Bin

Correct Answer: 1

Explanation:

A group allows analysts to combine individual dimension members into broader custom categories. For example, several product categories can be grouped under a new label such as Core Products. This is useful when the desired classification does not exist in the underlying data source. A set instead divides members into IN and OUT subsets, which is more useful for comparisons or membership-based logic. Parameters store independent user-controlled values, while bins group continuous numeric values into intervals. When the requirement is to consolidate categorical members into a named category, a group is the appropriate Tableau feature.

Question 178.

Which Tableau feature should an analyst use to identify a subset of customers that can be classified as IN or OUT?

1. Group
   2. Set
   3. Bin
   4. Hierarchy

Correct Answer: 2

Explanation:

A set defines a subset of dimension members and classifies each member as either IN or OUT of the set. Sets can be created manually, by condition, by Top N criteria, or updated interactively through set actions. This makes them highly useful for comparing selected customers with all other customers, analyzing cohorts, or driving conditional calculations. Groups merge members into broader categories, bins organize numeric values, and hierarchies support drill-down. When the analytical requirement specifically involves membership in a subset, a set is the most appropriate feature.

Question 179.

A dashboard should allow users to select a customer and compare that customer with all other customers without removing the others from the visualization. Which combination is most appropriate?

1. Filter action only
   2. URL action only
   3. Set action with a calculation based on IN/OUT membership
   4. Extract filter

Correct Answer: 3

Explanation:

A set action can update the membership of a set based on user selection. A calculated field can then distinguish the selected customer as IN the set and all other customers as OUT. This allows the dashboard to compare the selected customer with the rest of the population while keeping all marks visible. A filter action would typically remove unrelated customers and therefore eliminate comparison context. URL actions navigate externally, and extract filters restrict stored data. Set actions are particularly effective for interactive focus-versus-context analysis where viewers need to compare a selected entity with a broader population.

Question 180.

An analyst wants selecting a state on a map to filter several other worksheets in the same dashboard. Which feature should be configured?

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

Correct Answer: 4

Explanation:

A filter action passes selected values from a source worksheet to one or more target worksheets and restricts the target data accordingly. If State is selected on a map, Tableau can filter charts, tables, and other views to show only data associated with that state. Filter actions can be configured for selection, hover, or menu behavior and can target specific sheets. Highlight actions keep unrelated marks visible, while parameter actions update parameters and URL actions open external resources. When the objective is to restrict other dashboard views based on a user’s selection, a filter action is the appropriate Tableau feature.