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

 

Question 221.

An analyst wants a worksheet to display only customers whose SUM(Sales) is greater than $25,000. Which filter type is most appropriate?

1. Measure filter
   2. Context filter only
   3. Extract filter
   4. Geographic filter

Correct Answer: 1

Explanation:

A measure filter is appropriate when the condition depends on an aggregated quantitative value such as SUM(Sales). If Customer Name is in the view, Tableau can aggregate Sales for each customer and then apply a measure filter that retains only those with totals above $25,000. A context filter can affect the order of operations but does not itself replace the need for the measure condition. Extract filters operate much earlier and restrict stored records, while geographic filters are based on location fields. For threshold filtering on an aggregated measure, a measure filter is the most direct solution.

Question 222.

Which Tableau field type usually produces headers rather than an axis when placed on Rows or Columns?

1. Continuous measure
   2. Discrete field
   3. Continuous date only
   4. Generated latitude

Correct Answer: 2

Explanation:

Discrete fields typically create headers for their distinct members. Tableau generally displays discrete pills in blue. For example, placing a discrete Region field on Rows creates separate headers such as East, West, Central, and South. Continuous fields, shown in green, usually create axes because they represent a range of values. A date can be either discrete or continuous depending on how it is configured. Understanding this distinction is important because changing a field between discrete and continuous can dramatically change both the structure and appearance of the visualization.

Question 223.

An analyst wants to display a continuous timeline of monthly Sales rather than separate Month headers. What should be used?

1. Discrete MONTH(Order Date)
   2. Product hierarchy
   3. Continuous Month date value
   4. Set control

Correct Answer: 3

Explanation:

Using a continuous Month date value creates an axis across time, allowing Tableau to display a chronological sequence of months. This is ideal for line charts and other time-series visualizations where continuity matters. A discrete Month date part usually creates separate headers and may group all January values together depending on the date configuration. Product hierarchies and set controls are unrelated to date-axis behavior. Analysts should distinguish between date parts and date values because they answer different questions: date parts emphasize categories such as month names, while continuous date values emphasize progression through time.

Question 224.

Which Tableau option should an analyst use to display the actual date values rather than only a date part such as Month or Year?

1. Group
   2. Alias
   3. Bin
   4. Exact Date

Correct Answer: 4

Explanation:

Exact Date allows Tableau to use the complete date value rather than reducing it to a higher-level date part such as year, quarter, or month. This is useful when analysts need one mark per actual date or when a precise date axis is required. Exact Date can be configured as discrete or continuous depending on the desired visualization. Groups and bins reorganize dimension members or numeric values, while aliases change display labels. When the requirement is to work with the full underlying date value rather than an extracted date component, Exact Date is the appropriate choice.

Question 225.

An analyst wants to sort Sub-Category alphabetically rather than by a measure. Which Tableau sort approach should be used?

1. Alphabetic sort
   2. Top N filter
   3. Context filter
   4. Rank table calculation

Correct Answer: 1

Explanation:

An alphabetic sort orders dimension members according to their names rather than according to a measure. This is appropriate when the intended order is simply A to Z or Z to A. A Top N filter removes members outside a specified rank, while a context filter affects filter order. A rank table calculation assigns numerical positions based on measure values. Tableau supports several sorting methods, so the analyst should select the approach that aligns with the analytical purpose. For straightforward name-based ordering, an alphabetic sort is the correct choice.

Question 226.

Which Tableau option lets an analyst manually arrange dimension members into a custom order?

1. Forecast
   2. Manual sort
   3. Extract refresh
   4. Trend line

Correct Answer: 2

Explanation:

Manual sorting allows the analyst to place dimension members in a specific custom sequence rather than relying on alphabetical order or a measure-based sort. This is useful for business-defined sequences such as Low, Medium, High or Bronze, Silver, Gold. Tableau can preserve that custom ordering in the worksheet. Forecasting and trend lines provide analytical modeling, while extract refreshes update stored data. Manual sort is therefore the appropriate option when the display order should reflect a business rule that is not naturally alphabetical or based on a quantitative measure.

Question 227.

An analyst wants to create categories for Sales values such as Low, Medium, and High based on thresholds. Which calculated-field structure is most suitable?

1. SUM() only
   2. COUNTD() only
   3. IF/ELSEIF or CASE-style logic
   4. ATTR() only

Correct Answer: 3

Explanation:

Conditional logic such as IF, ELSEIF, ELSE, and END can classify numeric values according to thresholds. For example, Sales below one threshold can be labeled Low, values between thresholds Medium, and higher values High. CASE is also useful when matching exact values, although threshold comparisons often use IF or ELSEIF because the conditions involve ranges. SUM and COUNTD are aggregation functions rather than categorization logic, while ATTR checks whether a mark has one consistent underlying value. Conditional calculated fields are a common way to create business-friendly categories from quantitative data.

Question 228.

Which Tableau function should be used when several exact Region values need to be mapped to different labels in a calculation?

1. WINDOW_SUM()
   2. DATEADD()
   3. ZN()
   4. CASE

Correct Answer: 4

Explanation:

CASE is well suited to comparing one expression against several exact values. For example, a CASE statement can evaluate Region and return one label for East, another for West, and so forth. This is usually easier to read than a long series of nested IF statements when the logic consists mainly of equality comparisons. WINDOW_SUM is a table calculation, DATEADD performs date arithmetic, and ZN handles null numeric values. CASE provides a concise and maintainable way to translate discrete values into custom labels or categories.

Question 229.

Which Tableau function can test whether a string ends with a specific suffix?

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

Correct Answer: 1

Explanation:

ENDSWITH() returns TRUE when a string ends with the specified substring. For example, ENDSWITH([Product Code], “-US”) can identify codes ending in -US. This is useful for classifications based on standardized suffixes. STARTSWITH() checks the beginning of a string, while LEFT returns a specified number of characters from the beginning. LEN returns the total string length. Using purpose-specific Boolean string functions makes calculations easier to understand and maintain than manually extracting characters and comparing them when the requirement is simply to check a prefix or suffix.

Question 230.

Which Tableau function should be used to convert a text value to lowercase?

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

Correct Answer: 2

Explanation:

LOWER() converts alphabetic characters to lowercase. It is useful for normalizing strings when source data contains inconsistent capitalization, such as Enterprise, ENTERPRISE, and enterprise. Normalization can improve grouping, filtering, and comparisons by ensuring logically equivalent values are represented consistently. UPPER() performs the opposite transformation, while TRIM removes leading and trailing spaces. REPLACE substitutes specific text. LOWER is therefore the appropriate function when case normalization to lowercase is needed.

Question 231.

An analyst wants to extract the first three characters of a Customer Code. Which Tableau function should be used?

1. RIGHT()
   2. MID()
   3. LEFT()
   4. FIND()

Correct Answer: 3

Explanation:

LEFT() returns a specified number of characters from the beginning of a string. For example, LEFT([Customer Code],3) returns the first three characters. This is useful when an identifier contains a meaningful prefix such as region, product family, or account type. RIGHT extracts characters from the end, MID begins at a specified internal position, and FIND identifies where a substring occurs. When a fixed prefix is required, LEFT is the most direct and readable Tableau string function.

Question 232.

Which Tableau function is most appropriate for removing unwanted spaces from the beginning and end of a text field?

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

Correct Answer: 4

Explanation:

TRIM() removes leading and trailing whitespace from a string. This can prevent seemingly identical values from being treated as different members due to invisible spaces. For example, East and East might otherwise behave differently in filters or groups. REPLACE can modify specified substrings, LOWER changes case, and LEFT extracts a prefix. TRIM is a simple but important data-cleaning function, especially when working with manually entered or imported text values that may contain inconsistent spacing.

Question 233.

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’,[Ship Date])
   4. DAY([Order Date]) + DAY([Ship Date])

Correct Answer: 1

Explanation:

DATEDIFF() calculates the number of date boundaries between two dates using a specified unit. With ‘day’ as the date part, the expression returns the number of days between Order Date and Ship Date. This is useful for shipping duration, response times, customer tenure, and similar elapsed-time calculations. DATEADD shifts a date by a specified interval rather than calculating a difference. DATETRUNC truncates a date to a boundary, and adding day numbers does not represent elapsed time correctly. DATEDIFF is therefore the proper Tableau function for measuring the difference between two dates.

Question 234.

Which Tableau function should be used to move a date backward by seven days?

1. DATEDIFF()
   2. DATEADD()
   3. DATEPART()
   4. DATETRUNC()

Correct Answer: 2

Explanation:

DATEADD() adds or subtracts a specified number of date units. To move a date back seven days, the analyst can use a negative interval, such as DATEADD(‘day’,-7,[Date]). DATEDIFF measures distance between two dates, while DATEPART extracts a component such as year or month. DATETRUNC returns the beginning of a specified time period. Because the requirement is to create a new date shifted backward by a known interval, DATEADD is the correct function.

Question 235.

Which Tableau function returns a date truncated to the beginning of its year?

1. YEAR()
   2. DATEPART()
   3. DATETRUNC(‘year’,[Date])
   4. DATEADD()

Correct Answer: 3

Explanation:

DATETRUNC(‘year’,[Date]) returns a date representing the beginning of the year containing the original date. For example, a date in September 2026 would be truncated to January 1, 2026. This is different from YEAR(), which returns only the numeric year component. DATEPART similarly extracts a selected component rather than returning a full date. DATEADD shifts a date forward or backward. DATETRUNC is useful when analysts need consistent period-start dates for grouping, joining, or calculations.

Question 236.

Which Tableau function returns the current date and time rather than only the current date?

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

Correct Answer: 4

Explanation:

NOW() returns the current date and time, making it appropriate when time-of-day precision is required. TODAY() returns the current date without the same time component. NOW can be useful for calculating the age of recent events, monitoring freshness, or building time-sensitive logic. DATE() converts compatible values into date form. NOWDATE() is not the standard Tableau function. Analysts should choose between NOW and TODAY based on whether hours, minutes, and seconds matter to the calculation.

Question 237.

Which Tableau feature allows an analyst to combine Category and Sub-Category into an ordered drill-down structure?

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

Correct Answer: 1

Explanation:

A hierarchy organizes related dimensions into levels that users can expand or collapse. Creating a hierarchy with Category above Sub-Category allows users to begin with broad categories and drill into finer details. Hierarchies improve navigation and make it possible to use one visualization for both summary and detailed analysis. Sets define subset membership, groups combine members into categories, and bins divide numeric values into ranges. For ordered drill-down behavior, a hierarchy is the appropriate Tableau feature.

Question 238.

Which Tableau feature should be used when several states need to be combined into custom sales territories?

1. Parameter
   2. Group
   3. Bin
   4. Measure Names

Correct Answer: 2

Explanation:

Groups allow analysts to combine several dimension members into custom categories. For example, selected states can be grouped into territories such as Northeast, Southeast, or West. This can be done directly in Tableau without changing the source system. Parameters store independent values, bins group numbers, and Measure Names is a generated field used with multiple measures. When business-defined territories are not already present in the source data, a group is a straightforward way to create them.

Question 239.

Which Tableau feature is best for identifying the top 20 customers by Sales as a reusable IN/OUT classification?

1. Group
   2. Bin
   3. Top N set
   4. Hierarchy

Correct Answer: 3

Explanation:

A Top N set can dynamically classify the highest-performing dimension members as IN the set and all remaining members as OUT. For example, a set can contain the top 20 customers based on SUM(Sales). Unlike a simple Top N filter, the set can be used in calculations, Color, comparisons, or dashboard actions while retaining both IN and OUT members when desired. Groups combine members into custom categories, bins organize numeric ranges, and hierarchies provide drill-down structure. A Top N set is therefore ideal for reusable top-performer classification.

Question 240.

A dashboard user should be able to click a customer and dynamically compare that customer with all other customers while keeping the full population visible. Which Tableau feature is most appropriate?

1. Filter action
   2. URL action
   3. Extract filter
   4. Set action

Correct Answer: 4

Explanation:

A set action can update set membership when a user selects a customer. The selected customer can be classified as IN the set while the remaining customers stay OUT, and a calculation can then compare the selected member with the broader population. This preserves context because unrelated customers do not need to be filtered away. A filter action would typically remove nonmatching data, while a URL action opens an external resource. Extract filters restrict stored records and are not interactive dashboard controls. For selected-versus-rest analysis with the full population retained, a set action is the most appropriate Tableau feature.