Tableau TDA-C01 Practice Test Questions and Exam Dumps Part18 Q341-360

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

 

Question 341.

An analyst wants to create a worksheet that displays one mark for each customer, with Sales on the x-axis and Profit on the y-axis. Which additional field should be added to Detail to create one mark per customer?

  1. Customer Name
    2. Sales
    3. Profit
    4. Measure Names

Correct Answer: 1

Explanation:

Placing Customer Name on Detail increases the level of detail of the scatter plot so Tableau creates a separate mark for each customer. Sales and Profit define the position of each mark on the two axes, while Customer Name determines the granularity. If Customer Name were not added, Tableau might aggregate all records into a smaller number of marks depending on the other dimensions in the view. Detail is useful when analysts want more marks without displaying additional labels. Adding Sales or Profit to Detail would not create customer-level marks because those fields already define the quantitative axes.

Question 342.

Which Tableau Marks card property should be used when an analyst wants the size of each circle in a scatter plot to represent Quantity?

  1. Label
    2. Size
    3. Detail
    4. Tooltip

Correct Answer: 2

Explanation:

Placing Quantity on Size causes Tableau to vary the size of marks according to the measure’s value. Larger values generate larger marks, while smaller values generate smaller ones. This provides an additional quantitative encoding beyond the x- and y-axis measures. Label would display text, Detail would change the level of detail, and Tooltip would add information shown on hover. Analysts should use size carefully because viewers are less precise at comparing mark area than position. Even so, Size can be useful when a third quantitative measure needs to be represented within a scatter plot.

Question 343.

An analyst wants to display Product Category using different mark colors while keeping each customer as a separate mark. Where should Product Category be placed?

  1. Tooltip
    2. Pages
    3. Color
    4. Size

Correct Answer: 3

Explanation:

Placing Product Category on Color assigns a distinct color to each category, allowing viewers to distinguish customer marks visually. This is especially useful in scatter plots where multiple categories need to be compared simultaneously. Customer can remain on Detail so each customer has its own mark. Tooltip only displays information on hover, Pages lets users step through values sequentially, and Size changes mark size. Color is the Marks card property designed to encode a field visually through categorical colors or continuous gradients.

Question 344.

Which Tableau feature should be used when an analyst wants to display additional values only when a user hovers over a mark?

  1. Label
    2. Color
    3. Detail
    4. Tooltip

Correct Answer: 4

Explanation:

Tooltips display contextual information when a user hovers over a mark. Analysts can customize tooltip text and insert dimensions, measures, calculated fields, and explanatory text without permanently cluttering the visualization. This is useful when the chart should remain visually clean but users still need access to detailed values. Labels remain visible directly on the marks, Color changes mark appearance, and Detail changes granularity. Tooltips therefore provide an effective way to deliver secondary information on demand while preserving a simple visual design.

Question 345.

An analyst wants a worksheet title to show the currently selected Region parameter value. What should the analyst do?

  1. Insert the parameter value into the title
    2. Create a union
    3. Convert the parameter to a measure
    4. Use a data source filter only

Correct Answer: 1

Explanation:

Tableau allows parameters and other dynamic fields to be inserted into worksheet and dashboard titles. If a Region parameter controls the analysis, inserting its current value into the title helps viewers understand what context is being displayed. The title updates automatically when the parameter changes. This is especially helpful in parameter-driven dashboards where one worksheet may represent different measures, regions, scenarios, or thresholds. A union combines rows from tables, and converting a parameter to a measure is not required. A data source filter also does not automatically provide dynamic title text.

Question 346.

Which Tableau feature should be used to create a user-controlled threshold that can be changed without editing the workbook?

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

Correct Answer: 2

Explanation:

A parameter is an independent value that can be exposed to users through a control. It can hold numbers, strings, dates, or Boolean values and can be referenced in calculations, reference lines, filters, and other workbook logic. For example, a user could select a threshold of 50,000 and a calculated field could classify marks above or below that value. Groups combine dimension members, bins create numeric ranges, and hierarchies organize drill paths. Parameters are therefore the most appropriate Tableau feature when users need to adjust a value interactively without modifying the workbook structure.

Question 347.

Which Tableau feature should an analyst use when a user needs to choose among several business scenarios such as Conservative, Expected, and Aggressive?

  1. Extract filter
    2. Context filter
    3. Parameter
    4. Join

Correct Answer: 3

Explanation:

A parameter can present a predefined list of scenario values such as Conservative, Expected, and Aggressive. Calculated fields can then reference the selected parameter to change assumptions, thresholds, growth rates, or displayed metrics. This supports what-if analysis without changing the underlying source data. Extract and context filters restrict records rather than store independent scenario choices. Joins combine tables. Parameters are specifically suited to user-controlled inputs that affect calculations and can be reused across several worksheets in a dashboard.

Question 348.

An analyst wants to identify all customers whose Sales exceed a user-selected target. Which approach is most appropriate?

  1. Create a static group
    2. Use a hierarchy
    3. Create a union
    4. Create a parameter and a calculated field comparing Sales with that parameter

Correct Answer: 4

Explanation:

A parameter can store the user-selected Sales target, while a calculated field can compare each relevant Sales value with the parameter and return a classification such as Above Target or Below Target. This makes the threshold dynamic and user controlled. The resulting calculation can be used on Color, Filters, or Label. A static group would not update as the target changes. Hierarchies enable drill-down, and unions combine similarly structured tables. Parameter-driven threshold calculations are a common Tableau pattern for interactive business dashboards.

Question 349.

Which Tableau function should be used to count the number of unique customers in a dataset?

  1. COUNTD([Customer ID])
    2. COUNT([Customer ID])
    3. SUM([Customer ID])
    4. ATTR([Customer ID])

Correct Answer: 1

Explanation:

COUNTD() returns the number of distinct values in a field. If a customer appears in many transaction rows, COUNTD counts that customer only once. This makes it appropriate for metrics such as unique customers, unique orders, or unique products. COUNT would count every non-null occurrence, which could significantly overstate the number of customers in transactional data. SUM would be meaningless for identifiers, while ATTR evaluates whether one common value represents underlying rows. Distinct counting is essential when the entity being measured can appear multiple times in the source.

Question 350.

Which Tableau aggregation returns the smallest value of a numeric measure?

  1. MAX()
    2. MIN()
    3. AVG()
    4. COUNT()

Correct Answer: 2

Explanation:

MIN() returns the smallest value of a measure at the current level of detail. It is useful for identifying minimum Sales, earliest numeric values, lowest costs, or other minimum metrics. MAX returns the largest value, AVG calculates the arithmetic mean, and COUNT counts non-null values. The dimensions in the view determine the groups over which MIN is calculated. For example, MIN(Sales) by Region returns the minimum Sales value separately for each region.

Question 351.

Which Tableau aggregation returns the largest value of a measure?

  1. MIN()
    2. AVG()
    3. MAX()
    4. COUNTD()

Correct Answer: 3

Explanation:

MAX() returns the largest value of a measure within the current level of detail. For example, MAX(Sales) by Category returns the highest Sales value represented within each category group. MIN returns the smallest value, AVG calculates the mean, and COUNTD counts unique values. MAX can be useful for identifying peak values, highest transaction amounts, latest numeric sequence values, or other extremes. As with all aggregations, the dimensions in the view determine how the calculation is partitioned.

Question 352.

Which Tableau aggregation calculates the arithmetic mean of a numeric measure?

  1. SUM()
    2. MEDIAN()
    3. COUNT()
    4. AVG()

Correct Answer: 4

Explanation:

AVG() calculates the arithmetic mean of a numeric field by dividing the total of the values by the number of values included in the aggregation. It is commonly used for average Sales, average Profit, average delivery time, and similar metrics. SUM calculates the total, COUNT counts records or non-null values, and MEDIAN returns the middle value after ordering the observations. Analysts should always consider the grain of the underlying data because averaging row-level values may not represent the same business metric as averaging entity-level totals.

Question 353.

An analyst wants to identify the median Sales value because extreme transactions are distorting the average. Which Tableau aggregation should be used?

  1. MEDIAN()
    2. AVG()
    3. SUM()
    4. MAX()

Correct Answer: 1

Explanation:

MEDIAN returns the middle value of an ordered set of observations. It is often less affected by extreme outliers than AVG and can therefore provide a better representation of a typical value in a skewed distribution. If a few transactions are unusually large, the average may increase significantly even though most transactions remain small. The median helps analysts understand the center of the distribution without giving extreme values as much influence. SUM returns the total, while MAX returns only the largest observation.

Question 354.

Which Tableau visualization is best for examining the distribution of a numeric field and identifying skew or unusual values?

  1. Line chart
    2. Histogram
    3. Pie chart
    4. Filled map

Correct Answer: 2

Explanation:

A histogram displays the frequency distribution of a continuous numeric field by grouping values into bins. It can reveal whether values are concentrated in certain ranges, whether the distribution is symmetric or skewed, and whether unusually large or small observations exist. Line charts are primarily suited to trends, pie charts to simple composition, and filled maps to geographic measures. Histograms are one of the most useful exploratory visualizations for understanding the shape and spread of quantitative data before more detailed analysis is performed.

Question 355.

Which Tableau feature is used to divide a continuous numeric field into regular ranges for a histogram?

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

Correct Answer: 3

Explanation:

Bins divide a continuous numeric field into discrete ranges of a specified size. These ranges can then be used in a histogram to show how many observations fall into each interval. For example, Sales values can be grouped into bins of 100. Groups combine categorical members, sets classify members as IN or OUT, and hierarchies provide drill-down structures. Bins are specifically designed for numeric distribution analysis and make continuous data easier to summarize visually.

Question 356.

Which Tableau operation combines rows from similarly structured tables such as separate monthly sales files?

  1. Join
    2. Relationship
    3. Blend
    4. Union

Correct Answer: 4

Explanation:

A union stacks records vertically from multiple tables that contain the same or compatible columns. If separate files contain January, February, and March Sales records with identical structures, a union combines all those rows into one continuous dataset. Joins combine columns based on matching fields, while relationships preserve separate logical tables. Data blending combines aggregated results from different sources. When the requirement is to append similar records from multiple tables, a union is the appropriate operation.

Question 357.

Which join type retains all rows from the left table and only matching rows from the right table?

  1. Left join
    2. Inner join
    3. Right join
    4. Full outer join

Correct Answer: 1

Explanation:

A left join preserves every row from the left table. If a matching key exists in the right table, the matching fields are added; otherwise, the right-side fields are null. This is useful when the left table represents the full population that must be preserved. Inner joins keep only matched records, right joins preserve all right-side records, and full outer joins preserve unmatched rows from both tables. Analysts should also examine join cardinality because repeated matching keys can increase row counts even when the chosen join type is correct.

Question 358.

What is a key benefit of relationships when tables have different levels of detail?

  1. They permanently flatten the tables before analysis
    2. They allow logical tables to preserve their own grain until Tableau generates a query
    3. They remove the need for matching fields
    4. They guarantee no nulls in the data

Correct Answer: 2

Explanation:

Relationships connect logical tables without immediately merging all rows into one physical table. This allows each table to preserve its natural level of detail. Tableau then determines how the tables should be queried based on the fields needed in the current visualization. This can help prevent duplicated measures when tables have different grains. Relationships still require meaningful matching fields and do not automatically solve all data-quality issues. Their primary advantage is flexible, context-aware querying while maintaining separate logical table structures.

Question 359.

Which Tableau dashboard action should be used when selecting a mark must update a parameter value?

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

Correct Answer: 3

Explanation:

A parameter action updates a parameter using a field value from a selected mark. This allows user interactions to drive calculations, dynamic titles, reference lines, thresholds, and other parameter-dependent logic. For example, selecting a Sales mark could update a target parameter used elsewhere in the dashboard. Filter actions restrict data, highlight actions emphasize related marks, and URL actions open external resources. Parameter actions are therefore the correct feature when dashboard interaction must directly modify the current value of a parameter.

Question 360.

A dashboard user selects a Region, and the analyst wants all unrelated marks in several target worksheets to disappear. Which Tableau action should be configured?

  1. Highlight action
    2. Set 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 those target views to matching records. If the user selects a Region, the target worksheets can display only data associated with that Region, causing unrelated marks to disappear. A highlight action would retain the full population and simply emphasize matches. Set actions modify set membership, while URL actions open external resources. When the goal is to reduce target views to matching data based on an interactive selection, a filter action is the appropriate Tableau dashboard feature.