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

 

Question 261.

An analyst wants to show the average Sales per Customer for each Region, even though Customer is not displayed in the view. Which Tableau calculation is most appropriate?

1. { INCLUDE [Customer ID] : SUM([Sales]) } used within an appropriate aggregation
   2. RUNNING_SUM(SUM([Sales]))
   3. { EXCLUDE [Region] : SUM([Sales]) }
   4. INDEX()

Correct Answer: 1

Explanation:

An INCLUDE level-of-detail expression adds a dimension to the calculation grain even when that dimension is not visible in the worksheet. By including Customer ID, Tableau can first calculate Sales at the customer level and then aggregate those customer-level results at Region. This is useful for metrics such as average customer sales because simply applying AVG to row-level Sales may not represent the average customer total. Running Total and INDEX are table calculations based on marks already displayed. EXCLUDE removes dimensions rather than adding finer detail. INCLUDE is therefore the appropriate LOD pattern when a hidden dimension must participate in an intermediate calculation.

Question 262.

A worksheet displays Category and Sub-Category. The analyst wants a calculated value that shows Category-level Sales for every Sub-Category mark. Which LOD expression type should be used?

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

Correct Answer: 2

Explanation:

An EXCLUDE LOD expression removes a dimension that is currently part of the visualization’s level of detail. If Category and Sub-Category are both displayed, excluding Sub-Category allows Tableau to calculate Sales at the Category level while still displaying the individual Sub-Category marks. This is useful for comparing each detailed member with its broader parent total. INCLUDE would add more detail, not remove it. Running Total and Rank are table calculations whose results depend on the displayed marks and addressing configuration. EXCLUDE directly expresses the requirement that one visible dimension should not participate in a particular calculation.

Question 263.

Which Tableau LOD expression is most appropriate when total Sales must always be calculated by Customer ID regardless of dimensions such as Region or Category added to the view?

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

Correct Answer: 3

Explanation:

A FIXED LOD expression calculates the measure at the explicitly stated dimensions, which in this case is Customer ID. { FIXED [Customer ID] : SUM([Sales]) } therefore establishes customer-level sales independent of most dimensions added to the worksheet. Tableau’s order of operations still matters because context filters and some earlier filters can affect the data available to the FIXED calculation. INCLUDE works relative to the view’s current level of detail, while EXCLUDE removes specified dimensions from that level. WINDOW_SUM is a table calculation. FIXED is appropriate when the desired calculation grain should remain consistently defined.

Question 264.

Which Tableau table calculation is best for displaying the cumulative value of Profit across months?

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

Correct Answer: 4

Explanation:

Running Total accumulates an aggregated measure as Tableau moves across the specified addressing dimension. If Month is arranged chronologically, applying Running Total to SUM(Profit) produces cumulative Profit through each month. This can support year-to-date profitability analysis and progress monitoring. The Compute Using setting is important because it determines the direction in which the accumulation occurs and where it resets. Percent of Total calculates relative contribution, Rank assigns ordering, and Difference compares marks rather than accumulating them. Running Total is therefore the appropriate quick table calculation for cumulative monthly values.

Question 265.

Which Tableau table calculation should an analyst use to show each month’s Sales as a percentage of total annual Sales?

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

Correct Answer: 1

Explanation:

Percent of Total divides each mark’s aggregated value by the total value in the current table-calculation partition. If the partition represents one year and Month is the addressing dimension, Tableau can show each month’s share of annual Sales. The analyst should verify the Compute Using and partition settings so that the denominator resets for each year if multiple years are shown. Running Total accumulates values over time, Difference compares marks, and Moving Average smooths values over a window. Percent of Total is the most direct approach when the analytical question focuses on contribution to a whole.

Question 266.

Which Tableau function can retrieve the Sales value from two marks before the current mark within a table calculation?

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

Correct Answer: 2

Explanation:

LOOKUP() returns an expression’s value from a relative position in the current table-calculation partition. An offset of -2 retrieves the value from two marks before the current mark, assuming the view is ordered and addressed correctly. This can be useful for comparing current Sales with a value from two months earlier or for creating custom period-lag calculations. INDEX returns the sequential position of the current mark, SIZE returns the number of marks in the partition, and RANK assigns a value-based ordering. LOOKUP is specifically designed to reference values from neighboring or nearby marks.

Question 267.

An analyst wants to calculate the average of SUM(Sales) across a three-month rolling window. Which feature is most appropriate?

1. Context filter
   2. FIXED LOD expression
   3. Moving Average table calculation
   4. Geographic role

Correct Answer: 3

Explanation:

A Moving Average table calculation calculates an average across a specified window of marks. For monthly Sales, the analyst can configure the window so that each value reflects the current month and selected preceding months. This smooths short-term volatility and makes longer-term patterns easier to identify. Because it is a table calculation, the result depends on the view’s ordering, addressing, and partitioning. A context filter changes filter evaluation order, while FIXED LOD expressions control aggregation granularity rather than rolling windows. Geographic roles apply to mapping. Moving Average is therefore the most appropriate Tableau feature for a rolling mean across months.

Question 268.

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

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

Correct Answer: 4

Explanation:

SIZE() returns the number of marks or rows in the current table-calculation partition. This can be useful for calculations that depend on how many marks exist, such as conditional logic, custom pagination, or determining whether sufficient data is available for a rolling calculation. Like other table calculations, SIZE depends on the partitioning defined by the worksheet. INDEX returns a mark’s sequential position, LOOKUP retrieves another mark’s value using a relative offset, and FIRST returns the offset from the current row to the first row in the partition. SIZE specifically answers how many marks belong to the active partition.

Question 269.

A source system stores Product Code as ABC-12345, and the analyst wants to extract only ABC. Which Tableau function is most appropriate?

1. LEFT([Product Code],3)
   2. RIGHT([Product Code],3)
   3. LEN([Product Code])
   4. UPPER([Product Code])

Correct Answer: 1

Explanation:

The LEFT() function returns a specified number of characters from the beginning of a string. LEFT([Product Code],3) returns ABC from ABC-12345. This is useful when codes have consistent prefixes that represent product families, business units, territories, or other categories. RIGHT extracts characters from the end of the string, LEN returns its character count, and UPPER changes capitalization. LEFT is therefore the most direct function when the desired content occupies a known fixed-length prefix at the start of a text field.

Question 270.

Which Tableau function should an analyst use to determine whether Product Name contains the text Desk anywhere in the value?

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

Correct Answer: 2

Explanation:

CONTAINS() returns TRUE when the specified substring appears anywhere within a string. For example, CONTAINS([Product Name],”Desk”) identifies product names containing Desk regardless of whether it appears at the beginning, middle, or end. STARTSWITH and ENDSWITH test only the beginning or end of the string, while LEFT returns characters rather than a Boolean test. CONTAINS is useful for classifications, calculated filters, and text-based flags. Analysts may also need to normalize capitalization first if source values are inconsistent and the matching behavior needs to be standardized.

Question 271.

Which Tableau function can remove leading and trailing spaces from values such as ” East “ before they are grouped or compared?

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

Correct Answer: 3

Explanation:

TRIM() removes whitespace from both ends of a string. This is important because hidden spaces can cause values that look identical to be treated as separate members. For example, “East” and “East “ may produce separate categories, fail to match cleanly, or behave unexpectedly in comparisons. REPLACE can substitute specified substrings, LOWER changes capitalization, and FIND returns the position of a substring. TRIM is a simple but effective data-cleaning function for text imported from spreadsheets, manually entered systems, and other sources where whitespace may not be consistently controlled.

Question 272.

Which Tableau string function should be used to replace Corp. with Corporate inside a text field?

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

Correct Answer: 4

Explanation:

REPLACE() substitutes occurrences of one substring with another in a text value. For example, REPLACE([Segment],”Corp.”,”Corporate”) can standardize an abbreviation for display or downstream calculations. This transformation occurs within Tableau and does not alter the original source field. TRIM removes surrounding spaces, LEFT extracts characters from the beginning, and FIND returns the position of a substring. REPLACE is particularly useful for normalizing known text patterns, correcting repeated abbreviations, or cleaning predictable source-system values when modifying the original data source is not practical.

Question 273.

Which Tableau function is most appropriate for calculating the number of days between a customer’s Signup Date and TODAY()?

1. DATEDIFF(‘day’,[Signup Date],TODAY())
   2. DATEADD(‘day’,[Signup Date],TODAY())
   3. DATETRUNC(‘day’,[Signup Date])
   4. DAY(TODAY())-[Signup Date]

Correct Answer: 1

Explanation:

DATEDIFF() calculates the difference between two date values using a specified unit. In this case, DATEDIFF(‘day’,[Signup Date],TODAY()) determines the number of day boundaries between signup and the current date. This can be used for customer tenure, account age, ticket age, and similar elapsed-time metrics. DATEADD shifts a date rather than measuring elapsed time, while DATETRUNC rounds a date to a time boundary. Subtracting a date directly from the numeric day component is not an appropriate calculation. DATEDIFF is the standard Tableau function for measuring intervals between two dates.

Question 274.

Which Tableau function should an analyst use to move a date six months into the future?

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

Correct Answer: 2

Explanation:

DATEADD() creates a shifted date by adding or subtracting a specified number of date units. DATEADD(‘month’,6,[Date]) moves the original date six months forward. Negative values can move dates backward. This function correctly handles changes across year boundaries and differing calendar months. DATEDIFF measures the distance between dates rather than shifting them, while MONTH and DATEPART extract components of a date. DATEADD is commonly used for renewal dates, expiration dates, projected milestones, comparison periods, and other calculations requiring a date offset.

Question 275.

Which Tableau function converts a date to the beginning of the month containing that date?

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

Correct Answer: 3

Explanation:

DATETRUNC(‘month’,[Date]) returns the first day of the month containing the original date while preserving a date data type. This makes it useful for monthly grouping, relationships, custom calculations, and consistent period comparisons. MONTH extracts only the month number, while DATEPART can extract a requested date component. DATEDIFF calculates elapsed date units. DATETRUNC is particularly useful when analysts need all dates in the same month to map to one period-start date while still retaining the year and other date context.

Question 276.

Which Tableau function returns the current date and time?

1. TODAY()
   2. DATE()
   3. DATEPARSE()
   4. NOW()

Correct Answer: 4

Explanation:

NOW() returns the current date and time. It is useful when calculations require time-of-day precision, such as the number of hours since an event or whether a record is older than a particular number of minutes. TODAY() returns the current date without the same timestamp precision. DATE converts compatible values into a date, while DATEPARSE interprets text according to a specified date format where supported. Analysts should choose NOW when hours, minutes, or seconds matter and TODAY when the business calculation is based only on the current calendar date.

Question 277.

An analyst has separate tables for January, February, and March with the same columns. Which operation should be used to combine them into a single table containing all rows?

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

Correct Answer: 1

Explanation:

A union combines rows vertically from tables with the same or compatible column structures. When January, February, and March tables contain the same fields, unioning them creates one dataset containing records from all three months. This is different from a join, which combines columns horizontally according to matching keys. Relationships preserve separate logical tables and determine how they interact based on the fields used in a view. Sets define dimension membership and do not combine source data. Union is therefore the correct operation when similarly structured tables represent different periods or partitions that need to be stacked together.

Question 278.

Which join type keeps only records that match the join condition in both physical tables?

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

Correct Answer: 2

Explanation:

An inner join returns rows only when the join keys match in both tables. Records that exist in only one table are excluded from the result. This is appropriate when the analysis should include only entities represented on both sides, but analysts should verify that valid records are not unintentionally lost because of incomplete or inconsistent join keys. A left join preserves all rows from the left table, a right join preserves all rows from the right, and a full outer join retains unmatched rows from both sides. Selecting the correct join type is important because it directly determines which records are available for downstream analysis.

Question 279.

An Orders table contains multiple rows per customer, and a Targets table contains one row per salesperson. The analyst wants to avoid unnecessarily duplicating target values through a physical join. Which Tableau modeling approach is often preferable?

1. Union the tables
   2. Convert Targets to a parameter
   3. Use a relationship when the tables represent different grains and the model supports it
   4. Create a bin from Target

Correct Answer: 3

Explanation:

Relationships allow logical tables to preserve their own levels of detail and let Tableau determine how to query them based on the fields used in a visualization. When Orders and Targets have different grains, a physical join may repeat target values across many order rows and can lead to incorrect aggregation if the repeated values are summed. A relationship can often avoid that premature row-level flattening. A union would stack rows rather than relate tables, while parameters and bins do not solve the data-modeling issue. Understanding the grain of each table is essential when deciding between relationships and physical joins.

Question 280.

A dashboard contains a map and three supporting charts. The analyst wants clicking a state on the map to restrict all three charts to that selected state. Which Tableau feature should be configured?

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

Correct Answer: 4

Explanation:

A filter action passes one or more selected values from a source worksheet to target worksheets and restricts the target data accordingly. The map can therefore act as an interactive filter: when a user selects a state, each supporting chart can be configured to display only records associated with that state. A highlight action would keep unrelated data visible while emphasizing matches. A parameter action updates a parameter, and a set action changes set membership. When the explicit goal is to remove unrelated records from multiple target views based on a user’s selection, a filter action is the most direct Tableau dashboard solution.