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

 

Question 361.

An analyst wants to display the top 10 customers by Sales, but only within the currently selected Product Category. Which Tableau configuration is most appropriate?

1. Make Product Category a context filter, then apply a Top 10 Customer filter based on SUM(Sales)
   2. Apply the Top 10 Customer filter and then convert Product Category to a measure
   3. Use a highlight action instead of filtering
   4. Create a histogram using Customer Name

Correct Answer: 1

Explanation:

A context filter establishes a subset of the data before later filters are evaluated. If Product Category is made a context filter, Tableau first limits the data to the selected category. The Top 10 Customer filter can then identify the highest-selling customers within that subset. Without the context filter, Tableau may identify the top customers across a broader population and then apply the category restriction afterward. This is a classic example of Tableau’s order of operations affecting analytical results. Highlight actions and histograms do not provide the required Top N filtering behavior.

Question 362.

Which Tableau filter type is most appropriate for keeping only marks where aggregated Profit is greater than zero?

1. Extract filter
   2. Measure filter
   3. Context filter only
   4. Data source filter

Correct Answer: 2

Explanation:

A measure filter operates on aggregated quantitative results such as SUM(Profit), AVG(Sales), or COUNT(Order ID). If the view contains dimensions such as Category and the analyst wants to keep only categories whose aggregated Profit is positive, a measure filter on SUM(Profit) is appropriate. Extract and data source filters restrict rows much earlier in Tableau’s processing order and would not directly evaluate the final aggregate per mark. Context filters establish a subset for later operations. When the filtering condition specifically depends on the result of an aggregation, a measure filter is generally the correct choice.

Question 363.

An analyst needs a calculation that returns total Sales at the Region level even when State and City are added to the worksheet. Which expression should be used?

1. { INCLUDE [Region] : SUM([Sales]) }
   2. { EXCLUDE [Region] : SUM([Sales]) }
   3. { FIXED [Region] : SUM([Sales]) }
   4. RUNNING_SUM(SUM([Sales]))

Correct Answer: 3

Explanation:

A FIXED level-of-detail expression calculates an aggregation at the dimensions explicitly named in the expression. { FIXED [Region] : SUM([Sales]) } therefore produces a Region-level total even when lower-level geographic dimensions such as State or City are added to the visualization. INCLUDE operates relative to the current view and adds finer detail, while EXCLUDE removes specified dimensions. Running Total is a table calculation evaluated on displayed marks. FIXED is useful when a metric must remain at a defined grain independently of most dimensions in the view, although Tableau’s filter order still determines which filters affect it.

Question 364.

Which Tableau LOD expression type is designed to remove a dimension currently present in the view from a particular calculation?

1. FIXED
   2. INCLUDE
   3. WINDOW
   4. EXCLUDE

Correct Answer: 4

Explanation:

EXCLUDE removes one or more dimensions from the level of detail used for an LOD calculation. For example, if Category and Sub-Category are both displayed, an EXCLUDE expression can ignore Sub-Category and calculate a broader Category-level value. This is useful for comparing detailed marks with parent-level totals while keeping the detail visible. INCLUDE performs the opposite behavior by adding dimensions to the calculation grain. FIXED defines an explicit level of detail independent of most dimensions in the view. EXCLUDE is therefore the natural choice when the calculation should ignore a displayed dimension.

Question 365.

A worksheet displays Region but not Customer. The analyst wants to calculate Sales at the Customer level before averaging those results by Region. Which LOD expression type is appropriate?

1. INCLUDE
   2. EXCLUDE
   3. Running Total
   4. Rank

Correct Answer: 1

Explanation:

INCLUDE adds a dimension to the calculation’s level of detail even if that dimension is not displayed. By including Customer ID, Tableau can first calculate customer-level Sales and then aggregate those values at the Region level. This pattern is useful for metrics such as average customer value, where simply applying AVG to transaction-level Sales may produce the wrong business result. EXCLUDE removes dimensions rather than adding them, while Running Total and Rank are table calculations based on marks already present in the view. INCLUDE is specifically designed for introducing finer hidden granularity into an LOD calculation.

Question 366.

Which Tableau table calculation should an analyst use to show cumulative Sales from the beginning of the year through each month?

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

Correct Answer: 2

Explanation:

Running Total accumulates an aggregated measure as Tableau progresses through the marks in the specified addressing direction. If Month is ordered chronologically, applying Running Total to SUM(Sales) creates a year-to-date Sales value for each month. The analyst should configure Compute Using so that the calculation moves across Month and restarts for each Year when multiple years are present. Difference and Percent Difference measure period-to-period change, while Rank assigns positions. For cumulative performance analysis, Running Total is the appropriate quick table calculation.

Question 367.

Which Tableau table calculation is most appropriate for showing each month’s Sales as a percentage of the total Sales for the year?

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

Correct Answer: 3

Explanation:

Percent of Total divides each mark by the total value for the current table-calculation partition. If the partition represents one year and Month is the addressing dimension, Tableau can display each month’s contribution to annual Sales. Correct partitioning is essential because the denominator depends on which marks Tableau considers part of the total. Running Total accumulates values, Difference compares one mark with another, and Rank orders marks by measure value. Percent of Total is the appropriate calculation when the analytical question concerns relative contribution to an overall total.

Question 368.

Which Tableau function can retrieve the Sales value from the immediately preceding row in the current table-calculation partition?

1. INDEX()
   2. SIZE()
   3. FIRST()
   4. LOOKUP(SUM([Sales]),-1)

Correct Answer: 4

Explanation:

LOOKUP() retrieves the value of an expression from another mark at a relative offset. An offset of -1 references the immediately preceding mark, assuming the view is sorted and addressed correctly. For example, LOOKUP(SUM([Sales]),-1) can return the previous month’s Sales in a monthly time series. This supports custom difference, growth, and comparison calculations. INDEX returns positional numbering, SIZE returns partition length, and FIRST returns the offset to the first row. LOOKUP is the correct function when a calculation needs direct access to a neighboring mark’s value.

Question 369.

Which Tableau table-calculation function returns the sequential position of the current mark within a partition?

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

Correct Answer: 1

Explanation:

INDEX() returns the sequential position of each mark within the table-calculation partition, beginning at 1. It is based on the current ordering of the marks rather than on their measure values. INDEX is useful for row numbering, advanced table-calculation logic, or filtering specific positional ranges. Changing the sort order or Compute Using configuration may change the returned values. SIZE reports the number of marks in the partition, while RANK_PERCENTILE and WINDOW_SUM perform different analytical calculations. When simple positional numbering is required, INDEX is the appropriate function.

Question 370.

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

1. COUNT()
   2. SIZE()
   3. INDEX()
   4. ATTR()

Correct Answer: 2

Explanation:

SIZE() returns the number of marks in the active table-calculation partition. This can be useful in calculations that behave differently depending on partition length or when determining whether enough observations exist for a rolling analysis. The result depends on how Tableau partitions the view, so changing dimensions or Compute Using can change the value. COUNT operates on underlying data values rather than simply reporting partition size. INDEX returns a mark’s position, while ATTR evaluates whether a single value represents the underlying records. SIZE specifically describes the number of displayed marks participating in the partition.

Question 371.

An analyst wants to smooth monthly Sales fluctuations by showing the average of the current month and the previous two months. Which Tableau feature is most appropriate?

1. FIXED LOD expression
   2. Reference line
   3. Moving Average table calculation
   4. Data source filter

Correct Answer: 3

Explanation:

A Moving Average table calculation computes an average across a rolling window of marks. For a three-month moving average, the analyst can configure the calculation to include the current month and two preceding months. This helps reduce short-term noise and makes broader patterns easier to identify. Because it operates on displayed aggregated marks, the chronological ordering and Compute Using settings are important. FIXED LOD expressions control aggregation granularity, reference lines display benchmarks, and data source filters restrict records. Moving Average is the most appropriate feature for rolling smoothing of a time series.

Question 372.

Which Tableau function is best for converting a null numeric result to zero?

1. ISNULL()
   2. COUNT()
   3. ATTR()
   4. ZN()

Correct Answer: 4

Explanation:

ZN() returns zero when a numeric expression is null and otherwise returns the original numeric value. It can simplify calculations when the intended business meaning of missing numeric data is zero. However, analysts should apply it carefully because a true zero and an unknown or missing value are not always equivalent. ISNULL only tests whether a value is null, while COUNT and ATTR are aggregation functions with different purposes. ZN is specifically designed for null-to-zero conversion of numeric expressions and is therefore the most direct choice.

Question 373.

Which Tableau function should be used when a null text value should be replaced with the string Unknown?

1. IFNULL([Field],”Unknown”)
   2. ZN([Field])
   3. COUNTD([Field])
   4. ATTR([Field])

Correct Answer: 1

Explanation:

IFNULL() returns the original expression when it is populated and a replacement value when the expression is null. For a text field, IFNULL([Field],”Unknown”) provides a clear label for missing values. ZN is intended specifically for numeric values and replaces null with zero. COUNTD counts distinct field values, while ATTR checks whether one consistent value represents the underlying records. IFNULL is useful when missing text, dates, or other compatible values should be replaced with a defined fallback in a calculated field.

Question 374.

Which Tableau function should an analyst use to test whether a string begins with CUS-?

1. CONTAINS()
   2. STARTSWITH()
   3. ENDSWITH()
   4. FIND()

Correct Answer: 2

Explanation:

STARTSWITH() returns TRUE when a string begins with the specified substring. For example, STARTSWITH([Customer Code],”CUS-“) can classify values that follow a customer-code naming standard. CONTAINS checks whether the substring appears anywhere, while ENDSWITH tests only the end of the string. FIND returns the position of a substring and can be used for more complex parsing, but STARTSWITH communicates the intended rule more directly. Purpose-specific string functions make calculated fields easier to read and maintain.

Question 375.

Which Tableau function should be used to determine whether a Product Description contains the word Premium anywhere in the text?

1. LEFT()
   2. RIGHT()
   3. CONTAINS()
   4. LEN()

Correct Answer: 3

Explanation:

CONTAINS() returns TRUE when the specified substring occurs anywhere within another string. For example, CONTAINS([Product Description],”Premium”) can identify products whose descriptions include that word regardless of where it appears. LEFT and RIGHT extract characters from the beginning or end, while LEN reports the number of characters. CONTAINS is especially useful for classification, filtering, and Boolean flags when the important text can appear at any position within a descriptive field.

Question 376.

Which Tableau function can replace all occurrences of a known substring inside another string?

1. TRIM()
   2. MID()
   3. FIND()
   4. REPLACE()

Correct Answer: 4

Explanation:

REPLACE() substitutes occurrences of one substring with another in a text value. For example, an analyst could replace a repeated abbreviation with its full business term or remove a known unwanted character by replacing it with an empty string. The transformation applies within Tableau and does not permanently modify the source data. TRIM removes leading and trailing spaces, MID extracts characters from an internal position, and FIND identifies the position of text. REPLACE is the appropriate function for predictable search-and-substitute text cleanup.

Question 377.

An analyst wants to calculate the number of days between Order Date and Ship Date. Which expression is most appropriate?

1. DATEDIFF(‘day’,[Order Date],[Ship Date])
   2. DATEADD(‘day’,[Order Date],[Ship Date])
   3. DATETRUNC(‘day’,[Order Date])
   4. DAY([Order Date])+DAY([Ship Date])

Correct Answer: 1

Explanation:

DATEDIFF() calculates the difference between two date values in a specified date unit. Using ‘day’ returns the number of day boundaries between Order Date and Ship Date and is commonly used for shipping time, resolution time, or customer tenure calculations. DATEADD shifts a date by an interval, while DATETRUNC reduces a date to the beginning of a specified period. Adding day components does not calculate elapsed time correctly. DATEDIFF is therefore the appropriate function when the requirement is to quantify the interval between two dates.

Question 378.

Which Tableau function should be used to return a date that is exactly one month after Order Date?

1. DATEDIFF()
   2. DATEADD(‘month’,1,[Order Date])
   3. DATETRUNC()
   4. MONTH()

Correct Answer: 2

Explanation:

DATEADD() moves a date forward or backward by a specified number of date units. DATEADD(‘month’,1,[Order Date]) returns a date one month after each Order Date. This properly handles transitions across years and month boundaries. DATEDIFF measures the interval between dates, while DATETRUNC reduces a date to a time-period boundary. MONTH extracts the month component. DATEADD is appropriate for renewal dates, follow-up dates, expiration periods, and other business rules involving date offsets.

Question 379.

A data model contains a detailed Orders table and a monthly Targets table at a different grain. Which Tableau approach can help preserve each table’s level of detail rather than physically duplicating target values across order rows?

1. Union
   2. Physical join only
   3. Relationship
   4. Bin

Correct Answer: 3

Explanation:

Relationships operate in Tableau’s logical layer and allow each logical table to preserve its natural level of detail. Tableau determines how to combine the data depending on which fields are used in the visualization. This can help avoid problems that occur when a monthly Targets table is physically joined to a highly detailed Orders table, potentially repeating target values across many order rows. Relationships still require correct matching fields and sound data modeling. A union stacks rows, while bins group numerical values. For tables with different grains, relationships are often the more appropriate modeling choice.

Question 380.

A dashboard user selects a Product Category in one chart, and the analyst wants several other worksheets to display only records from that category. Which feature should be configured?

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

Correct Answer: 4

Explanation:

A filter action uses values selected in a source worksheet to restrict the data shown in one or more target worksheets. Selecting a Product Category can therefore cause related tables, maps, and charts to display only records associated with that category. This creates intuitive dashboard interactivity because the visualization itself functions as a filter control. Highlight actions preserve unrelated marks and only emphasize matching ones. Parameter actions update parameter values, while URL actions open external pages. When unrelated records should be removed from target views based on a selection, a filter action is the correct Tableau feature.