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

 

Question 141.

An analyst wants to show the percentage of total Sales contributed by each Sub-Category within its own Category. Which approach is most appropriate?

1. Apply Percent of Total to SUM(Sales) and configure the table calculation to compute within each Category
   2. Use a FIXED LOD expression at the entire data-source level
   3. Convert Sales to a discrete dimension
   4. Apply an extract filter to Sub-Category

Correct Answer: 1

Explanation:

Percent of Total is a table calculation that divides each mark by the total of its current partition. If the goal is to show each Sub-Category’s contribution within its own Category, the analyst must configure the table calculation so Category defines the partition and Sub-Category defines the addressing direction. This causes the denominator to reset for every Category. A workbook-wide FIXED calculation could produce a different denominator, while converting Sales to a dimension would prevent the intended aggregation. Extract filters control stored data rather than percentage calculations. Correct partitioning is essential because the same Percent of Total calculation can produce very different results depending on Compute Using.

Question 142.

Which Tableau feature allows a user to dynamically change the number used in a Top N filter?

1. Set only
   2. Parameter
   3. Group
   4. Geographic hierarchy

Correct Answer: 2

Explanation:

A parameter can store a user-selected number and can be referenced by a Top N dimension filter. For example, instead of hard-coding Top 10 Customers, the analyst can create an integer parameter called Top N and use it in the filter configuration. The user can then select 5, 10, 20, or another allowed number. This makes the dashboard more interactive and reduces the need for separate worksheets. Sets and groups organize members, while geographic hierarchies support location drill-down. A parameter is the most flexible Tableau feature for allowing users to control a numerical setting such as the value of N.

Question 143.

An analyst needs to compare actual Sales with a user-selected target and color marks differently depending on whether they exceed that target. Which design is most appropriate?

1. Create a union between Sales and the target
   2. Use a context filter only
   3. Create a numeric parameter and a calculated field that compares Sales with the parameter
   4. Convert Sales to a string

Correct Answer: 3

Explanation:

A numeric parameter can store the user-selected target, and a calculated field can compare the relevant sales aggregation with that parameter. For example, the calculation might return Above Target when SUM(Sales) exceeds the selected threshold and Below Target otherwise. The resulting category can then be placed on Color. This pattern provides dynamic threshold analysis and can also drive reference lines or labels. A union is a data-combination operation, while a context filter affects Tableau’s order of operations. Converting Sales to text would prevent normal numeric comparison. Parameters and calculated fields are therefore the best combination for adjustable target-based visual logic.

Question 144.

Which Tableau feature should an analyst use to let users choose among several predefined values without directly filtering a source field?

1. Dimension filter
   2. Data source filter
   3. Extract filter
   4. Parameter

Correct Answer: 4

Explanation:

A parameter is an independent workbook value that users can select through a parameter control. It can contain a predefined list, a range, or other allowable values. Unlike a standard filter, a parameter does not automatically remove rows from a field. Instead, it influences calculations, reference lines, filters, titles, and other workbook logic when referenced. This makes parameters ideal for measure switching, adjustable thresholds, scenario selection, and what-if analysis. Dimension, data source, and extract filters directly restrict data. When the selection should act as a reusable input rather than directly filtering source records, a parameter is the appropriate Tableau feature.

Question 145.

A sales dashboard should display a different measure depending on whether the user selects Sales, Profit, or Quantity. Which calculated-field structure is most appropriate?

1. A CASE expression based on a parameter
   2. A geographic role
   3. A union
   4. A context filter only

Correct Answer: 1

Explanation:

A CASE expression can evaluate the selected value of a parameter and return the corresponding measure. For example, when the parameter equals Sales, the calculated field returns [Sales]; when it equals Profit, it returns [Profit]; and so on. The calculated field can then be used in the worksheet as a dynamic measure. This is a standard Tableau technique for reducing the number of nearly identical worksheets required by a dashboard. Geographic roles, unions, and context filters do not perform measure switching. Parameter-driven CASE calculations provide a clean and maintainable way to let users select which metric a visualization displays.

Question 146.

Which Tableau function returns the length of a text string?

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

Correct Answer: 2

Explanation:

LEN() returns the number of characters in a string. For example, LEN([Customer Name]) can be used to determine the length of each customer name. This may be useful for validation, classification, or other string-processing tasks. LEFT() returns characters from the beginning of a string, MID() returns characters from a specified position, and FIND() returns the position where a substring occurs. LEN does not modify the original string; it simply produces a numeric result representing its length. It is one of several useful Tableau string functions for cleaning and analyzing textual data.

Question 147.

Which Tableau function returns characters from the right side of a string?

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

Correct Answer: 3

Explanation:

RIGHT(string, number) returns the specified number of characters from the end of a string. For example, RIGHT([Product Code],4) returns the final four characters of the product code. This can be useful when standardized identifiers contain meaningful suffixes such as region codes, model numbers, or year indicators. LEFT() extracts from the beginning, while MID() extracts from a chosen position. FIND() identifies the position of a substring rather than returning a fixed number of ending characters. When a meaningful suffix needs to be extracted from structured text, RIGHT is the appropriate Tableau function.

Question 148.

An analyst wants to extract three characters beginning at the fifth character of a Product Code. Which Tableau function is most appropriate?

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

Correct Answer: 4

Explanation:

MID() returns a specified number of characters starting at a specified position within a string. This is useful for codes or identifiers in which meaningful information appears in a predictable internal position. For example, a Product Code might contain a business-unit code beginning with the fifth character. LEFT() and RIGHT() are appropriate when the required characters appear at the beginning or end of the field. LEN() only reports the string length. When the analyst needs a substring from an internal fixed position, MID provides the required functionality clearly and efficiently.

Question 149.

Which Tableau function returns the position at which one string first appears inside another string?

1. FIND()
   2. CONTAINS()
   3. LEN()
   4. TRIM()

Correct Answer: 1

Explanation:

FIND() returns the position of the first occurrence of a substring inside another string. This is useful when analysts need positional information rather than simply a true-or-false result. For example, it can help locate a delimiter or identify where a particular code begins within a larger text value. CONTAINS() only indicates whether a substring exists, while LEN() returns string length and TRIM() removes leading and trailing spaces. FIND is particularly useful when combined with other string functions to parse semi-structured text where delimiters or markers appear at variable positions.

Question 150.

Which Tableau function should an analyst use to replace one substring with another inside a text field?

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

Correct Answer: 2

Explanation:

REPLACE() substitutes occurrences of one substring with another inside a string. For example, the analyst can replace an outdated product abbreviation with a standardized label or remove unwanted characters by replacing them with an empty string. This transformation occurs in the calculated result and does not permanently change the source data. TRIM() removes surrounding spaces, RIGHT() extracts characters from the end, and UPPER() changes capitalization. REPLACE is therefore the appropriate string function when known text within a field must be substituted with different text as part of Tableau data preparation or analysis.

Question 151.

An analyst wants a calculation to return the first non-null value between two compatible fields. Which Tableau function is most appropriate?

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

Correct Answer: 3

Explanation:

IFNULL(expression, replacement) returns the first expression when it is not null and otherwise returns the specified replacement value. If two compatible fields represent alternative sources for the same information, an expression such as IFNULL([Primary Phone],[Secondary Phone]) can return the primary value when available and fall back to the secondary value otherwise. ISNULL() only tests whether a value is null, while ZN() is specifically intended to replace null numeric values with zero. COUNT is an aggregation rather than a null-handling function. For a direct fallback between two compatible values, IFNULL is appropriate.

Question 152.

Which Tableau function evaluates whether an expression is null and returns TRUE or FALSE?

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

Correct Answer: 4

Explanation:

ISNULL() tests whether the supplied expression contains a null value and returns a Boolean result. It is useful inside IF statements and other calculated-field logic. For example, an analyst could create a classification that labels missing values differently from populated ones. IFNULL() returns a replacement when a null is encountered, whereas ZN replaces null numeric values with zero. ATTR is an aggregation that checks whether the underlying values are all the same. Because ISNULL simply answers whether a value is missing, it is the correct function when the analyst needs a true-or-false null test rather than a replacement value.

Question 153.

Which Tableau date function returns the month number from a date field?

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

Correct Answer: 1

Explanation:

MONTH() extracts the month component from a date value and returns the corresponding month number. This can be useful for seasonal comparisons, month-based classifications, or calculations that depend on the calendar month. Analysts should distinguish using MONTH as a function in a calculation from selecting a discrete or continuous month date level in a visualization, because the presentation and behavior can differ. DATEADD() changes a date, DATETRUNC() truncates a date to a specified boundary, and DATEDIFF() measures the distance between two dates. When the requirement is to extract the month component, MONTH is the appropriate function.

Question 154.

An analyst wants to calculate the number of months between Customer Start Date and the current date. Which expression is most appropriate?

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

Correct Answer: 2

Explanation:

DATEDIFF() calculates the difference between two dates using a specified date unit. DATEDIFF(‘month’,[Start Date],TODAY()) therefore returns the number of month boundaries between the customer’s start date and the current date. This can be used to estimate tenure or duration in months. DATEADD() shifts a date rather than calculating elapsed time, while DATETRUNC() rounds a date down to a period boundary. Subtracting a date directly from a month number is not valid for this purpose. DATEDIFF is the appropriate choice whenever an analyst needs the elapsed number of days, months, years, or other supported units between two dates.

Question 155.

Which Tableau function should be used to move an Order Date one year into the future?

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

Correct Answer: 1

Explanation:

DATEADD() modifies a date by adding or subtracting a specified number of date units. For example, DATEADD(‘year’,1,[Order Date]) returns the date one year after each Order Date. Negative values can be used to shift backward. This is useful for renewal dates, comparison periods, expiration calculations, and projected milestones. DATEDIFF() measures elapsed date units between two dates, while DATEPART() and YEAR extract components from a date. Since the requirement is to produce a new shifted date rather than measure or extract a component, DATEADD is the correct function.

Question 156.

Which Tableau function truncates a date to the beginning of the quarter containing that date?

1. DATEPART(‘quarter’,[Order Date])
   2. DATEADD(‘quarter’,1,[Order Date])
   3. DATEDIFF(‘quarter’,[Order Date],TODAY())
   4. DATETRUNC(‘quarter’,[Order Date])

Correct Answer: 4

Explanation:

DATETRUNC(‘quarter’,[Order Date]) returns the date corresponding to the beginning of the quarter that contains the original Order Date. This creates a true date value that can be used for consistent quarterly grouping, relationships, calculations, and display. DATEPART() returns a component such as the quarter number rather than the beginning date. DATEADD() shifts dates, and DATEDIFF() measures intervals. DATETRUNC is especially useful when analysts want to normalize individual dates to period boundaries such as week, month, quarter, or year.

Question 157.

Which Tableau feature is designed to let users drill from Country to State to City within a map or other visualization?

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

Correct Answer: 1

Explanation:

A hierarchy organizes related dimensions into ordered levels. A geographic hierarchy containing Country, State, and City allows viewers to drill from a broad geographic level into progressively finer detail. Tableau provides built-in hierarchies for some geographic and date fields, and analysts can also create custom hierarchies. Sets classify members as IN or OUT, bins group numeric values into ranges, and parameters provide user-selectable values. When the analytical requirement involves structured drill-down from summary to detail, a hierarchy provides the most direct and intuitive solution.

Question 158.

Which Tableau feature allows several members such as New York, New Jersey, and Pennsylvania to be combined into a custom category called Northeast?

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

Correct Answer: 2

Explanation:

A group combines individual dimension members into broader custom categories. The analyst can select New York, New Jersey, and Pennsylvania and group them under a label such as Northeast. Groups are useful when the desired classification is not already present in the source data. A set instead defines membership in an IN-versus-OUT subset, while a bin groups continuous numeric values into intervals. Parameters are independent user-controlled values. For manually combining several categorical members into one larger business category, a group is the appropriate Tableau feature.

Question 159.

Which Tableau feature should an analyst use to dynamically compare a selected subset of customers with all other customers?

1. Group only
   2. Bin
   3. Set
   4. Geographic role

Correct Answer: 3

Explanation:

A set divides dimension members into IN and OUT categories and is therefore well suited to comparing a selected subset with the rest of the population. Sets can be defined manually, by condition, or by Top N logic, and they can be modified interactively with set actions. A calculated field can then compare IN-set customers with OUT-of-set customers on metrics such as Sales or Profit. Groups permanently combine members into categories rather than maintaining subset membership. Bins organize numeric ranges, and geographic roles provide location meaning. Sets are therefore particularly powerful for cohort and selected-versus-remaining comparisons.

Question 160.

An analyst wants clicking a mark in one dashboard view to update a set and use that set to drive color in another worksheet. Which feature should be configured?

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

Correct Answer: 4

Explanation:

A set action changes the membership of a Tableau set based on user interaction with marks. Once the selected mark becomes a member of the set, the set can be used in calculated fields, filters, or visual encodings such as Color on another worksheet. This enables interactive selected-versus-unselected comparisons without necessarily removing any data. A filter action would restrict the target worksheet, while a highlight action would emphasize related marks without changing set membership. URL actions navigate to external resources. Set actions are particularly effective for dynamic cohort analysis, comparative dashboards, and interactive focus-plus-context visualizations.