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

 

Question 101.

An analyst wants to create a calculated field that returns High Profit when SUM(Profit) exceeds 100,000 and Standard Profit otherwise. Which expression is valid?

1. IF SUM([Profit]) > 100000 THEN “High Profit” ELSE “Standard Profit” END
   2. SUM(IF [Profit] > 100000)
   3. IF [Profit] = SUM(100000) THEN “High Profit”
   4. CASE SUM([Profit]) > 100000

Correct Answer: 1

Explanation:

The first expression correctly uses an aggregate measure inside an IF statement. Tableau evaluates SUM([Profit]) at the level of detail defined by the visualization and then returns one of two string values depending on the result. Because the condition uses an aggregate, the returned calculation is also aggregate. The other expressions either use invalid Tableau syntax or do not provide the required conditional result. Analysts must also avoid mixing aggregated and non-aggregated fields improperly in the same expression. When a business rule is based on an aggregated measure such as total Profit, the aggregation should be consistently applied within the calculated field.

Question 102.

Which Tableau function returns the absolute value of a number?

1. ROUND()
   2. ABS()
   3. SIGN()
   4. CEILING()

Correct Answer: 2

Explanation:

ABS() returns the absolute value of a numeric expression, removing any negative sign. For example, ABS(-250) returns 250. This function is useful when the analyst needs magnitude without regard to direction, such as absolute variance from a target or absolute distance between values. ROUND() controls decimal precision, while SIGN() identifies whether a number is positive, negative, or zero. CEILING() rounds a number upward to an integer or supported precision depending on the function usage. For converting both positive and negative numeric values into their non-negative magnitude, ABS() is the appropriate Tableau function.

Question 103.

An analyst wants to round a calculated Profit Ratio to two decimal places. Which Tableau function should be used?

1. ABS()
   2. INT()
   3. ROUND()
   4. FLOAT()

Correct Answer: 3

Explanation:

The ROUND() function rounds a numeric expression to a specified number of decimal places. For example, ROUND([Profit Ratio], 2) produces a value rounded to two decimal places. This is useful when the underlying calculation contains more precision than is needed for analysis or display. Formatting can also change how many decimals viewers see without changing the calculated value itself, so analysts should distinguish actual rounding from display formatting. ABS() returns magnitude, INT() converts a number to an integer, and FLOAT() converts compatible values to floating-point numbers. For mathematical rounding to a controlled precision, ROUND() is appropriate.

Question 104.

Which Tableau function converts a compatible value into an integer?

1. STR()
   2. DATE()
   3. FLOAT()
   4. INT()

Correct Answer: 4

Explanation:

INT() converts a compatible value into an integer. It is useful when a calculation requires an integer representation or when numeric values stored in another compatible format need to be converted. Analysts should understand that converting decimal values to integers may discard the fractional component rather than perform ordinary rounding. FLOAT() converts values to floating-point numbers, STR() converts values into strings, and DATE() converts compatible values into dates. Type-conversion functions are useful in Tableau when source systems provide fields in formats that do not match the analytical behavior the workbook requires.

Question 105.

Which Tableau function converts a value into text so it can be concatenated with another string in a calculated field?

1. STR()
   2. INT()
   3. DATEPARSE()
   4. ATTR()

Correct Answer: 1

Explanation:

STR() converts a value into a string representation. This is useful when numeric or date-derived values need to be combined with text. For example, an analyst might build a dynamic label by concatenating “Sales: “ with STR(SUM([Sales])) in an appropriate aggregate calculation. Without compatible data types, Tableau may reject the concatenation. INT() converts values to integers, while DATEPARSE() parses date strings according to a format. ATTR() is an aggregation that returns a common value when all underlying rows agree. For general conversion to text, STR() is the appropriate function.

Question 106.

Which Tableau function returns the year component of a date as a number?

1. DATE()
   2. YEAR()
   3. DATETRUNC()
   4. DATEADD()

Correct Answer: 2

Explanation:

YEAR() extracts the year component from a valid date or datetime value. For example, YEAR([Order Date]) might return 2026 for a date occurring in that calendar year. Date-part functions such as YEAR, MONTH, DAY, and DATEPART are useful when analysts need to classify or calculate based on individual date components. DATETRUNC() rounds a date down to a specified date boundary, while DATEADD() shifts a date by a specified interval. DATE() converts compatible expressions into date values. When the requirement is simply to obtain the numeric year component, YEAR() is the direct choice.

Question 107.

An analyst needs to add 30 days to an Order Date in a calculated field. Which function should be used?

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

Correct Answer: 3

Explanation:

DATEADD() adds or subtracts a specified number of date units from a date. A calculation such as DATEADD(‘day’, 30, [Order Date]) returns a date 30 days after each Order Date. Negative values can be used to move backward in time. DATEDIFF() calculates the difference between two dates, while DATETRUNC() truncates a date to a boundary such as the start of a month. DATEPART() extracts a component such as month or weekday. When the goal is to shift a date forward or backward by a specified amount, DATEADD() is the appropriate function.

Question 108.

Which Tableau function calculates the number of date units between two dates?

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

Correct Answer: 4

Explanation:

DATEDIFF() returns the difference between two dates in a specified unit such as days, months, quarters, or years. For example, DATEDIFF(‘day’, [Order Date], [Ship Date]) can calculate the number of day boundaries between ordering and shipping. This is commonly used for turnaround time, delivery delay, customer tenure, and other duration metrics. DATEADD() changes a date by adding an interval, while DATEPART() extracts one component of a date. DATETRUNC() reduces a date to the beginning of a specified period. For measuring elapsed date units between two date values, DATEDIFF() is the correct function.

Question 109.

Which Tableau function can return the first day of the month containing a given date?

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

Correct Answer: 1

Explanation:

DATETRUNC(‘month’,[Order Date]) truncates each date to the beginning of its month. For example, a date of September 26 would be converted to September 1 of the same year. This is useful for creating consistent month-level grouping, comparisons, and custom calculations. DATEADD() shifts a date rather than truncating it, while YEAR() extracts only the year component. DATEDIFF() calculates the number of specified date boundaries between two dates. DATETRUNC() is particularly valuable when analysts want a true date value representing the start of a month, quarter, week, or year.

Question 110.

Which Tableau function returns the current date without a time component?

1. NOW() only
   2. TODAY()
   3. DATEPARSE()
   4. MAKEDATE() only

Correct Answer: 2

Explanation:

TODAY() returns the current date. It is useful for calculations such as days since an order, customer age, or whether an expiration date has passed. NOW() returns the current date and time, which may be appropriate when time-of-day precision is required. DATEPARSE() converts a date string into a date using a specified pattern, while MAKEDATE() constructs a date from separate numeric year, month, and day components. For calculations that need the current calendar date without requiring the current timestamp, TODAY() is the most straightforward function.

Question 111.

An analyst wants to display a ratio only when Sales is not zero to avoid division-by-zero errors. Which calculation is most appropriate?

1. SUM([Profit]) / SUM([Sales]) with no condition
   2. COUNT([Sales]) / SUM([Profit])
   3. IF SUM([Sales]) <> 0 THEN SUM([Profit]) / SUM([Sales]) END
   4. ZN(SUM([Sales])) / SUM([Profit])

Correct Answer: 3

Explanation:

The conditional expression checks whether aggregated Sales is nonzero before performing the division. If Sales is zero, Tableau returns null because no ELSE result is specified, avoiding an invalid or misleading division. This pattern is useful when denominator values can legitimately be zero. Simply applying ZN to Sales would convert null to zero but would not prevent division by zero. COUNT also answers a different analytical question. Analysts should handle denominator conditions explicitly when ratio calculations could encounter zero or invalid values. Doing so makes the calculation more robust and reduces unexpected null, infinite, or undefined outputs.

Question 112.

Which Tableau function is commonly used to replace a null numeric expression with zero?

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

Correct Answer: 4

Explanation:

ZN() returns zero when its numeric argument is null and otherwise returns the original numeric value. This is especially convenient for calculations involving measures where null should logically be treated as zero. Tableau also provides IFNULL(), which can replace null values with a specified alternative of a compatible type, but ZN() is purpose-built for numeric zero replacement. ISNULL() only tests whether a value is null and returns a Boolean. ATTR() is an aggregation related to value uniqueness. Analysts should apply ZN only when zero genuinely represents the intended business meaning because missing data and zero are not always equivalent.

Question 113.

What does the IFNULL() function do in Tableau?

1. Returns a replacement value when the first expression is null
   2. Converts every zero to null
   3. Counts all null records
   4. Removes null records from the source data

Correct Answer: 1

Explanation:

IFNULL(expression, replacement) returns the original expression when it is not null and returns the specified replacement when it is null. Unlike ZN(), which specifically replaces null numeric values with zero, IFNULL can be used with other compatible data types as well. For example, IFNULL([Region],”Unknown”) can create a display value for missing region names. The function does not delete source rows or permanently modify data. It simply changes how the calculated result is evaluated within Tableau. Null handling is an important part of reliable calculated fields because missing data can otherwise propagate through expressions unexpectedly.

Question 114.

An analyst wants a calculation to test whether Product Name begins with the text Office. Which Tableau function is most appropriate?

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

Correct Answer: 2

Explanation:

STARTSWITH() returns true when a string begins with the specified substring. For example, STARTSWITH([Product Name], “Office”) evaluates whether each Product Name starts with that text. Tableau also provides ENDSWITH() for suffix testing and CONTAINS() for identifying a substring anywhere within the value. FIND() returns the position of a substring rather than directly expressing the Boolean intent as clearly. When the business rule specifically depends on the beginning of a string, STARTSWITH provides readable and purpose-specific logic.

Question 115.

Which Tableau function should be used to determine whether a string contains another string anywhere within it?

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

Correct Answer: 3

Explanation:

CONTAINS() returns a Boolean value indicating whether one string contains another substring. For example, CONTAINS([Product Name], “Chair”) identifies product names in which the text Chair appears anywhere. This is useful for classification, conditional labeling, and filtering based on text patterns. LEFT() and RIGHT() return characters from the beginning or end of a string, while TRIM() removes leading and trailing spaces. Although more complex text matching can sometimes require additional logic, CONTAINS is the clearest function when the analyst simply needs to test whether a substring appears anywhere inside another string.

Question 116.

Which Tableau function removes leading and trailing spaces from a string?

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

Correct Answer: 4

Explanation:

TRIM() removes whitespace from both the beginning and end of a string. This can be important when values from source systems include accidental spaces that interfere with grouping, matching, filtering, or comparisons. For example, “East” and “East “ can behave as different values unless the string is cleaned. LOWER() and UPPER() normalize letter case, while REPLACE() substitutes specified text. Data-cleaning calculations such as TRIM can improve analytical consistency, although persistent source-quality problems are often better addressed upstream when possible.

Question 117.

Which Tableau function converts alphabetic text to uppercase?

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

Correct Answer: 1

Explanation:

UPPER() converts alphabetic characters in a string to uppercase. It is commonly used for normalization when the source contains inconsistent capitalization. For example, east, East, and EAST can all be transformed to EAST before further comparison or grouping. LOWER() performs the opposite operation, converting text to lowercase. TRIM() removes surrounding whitespace, and STR() converts compatible values into text. Normalizing capitalization can help avoid unintended duplicate categories in visualizations and calculations, especially when source-system data-entry practices are inconsistent.

Question 118.

Which Tableau function returns a specified number of characters from the left side of a string?

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

Correct Answer: 2

Explanation:

LEFT(string, number) returns the specified number of characters from the beginning of a string. For example, LEFT([Product Code],3) returns the first three characters of Product Code. This is useful when identifiers contain meaningful prefixes or when analysts need to create categories from standardized codes. RIGHT() retrieves characters from the end, while MID() extracts characters beginning at a specified position. LEN() returns the number of characters in a string. When a fixed-length prefix needs to be extracted, LEFT is the appropriate function.

Question 119.

An analyst wants users to select a numeric target and have a reference line move dynamically based on the selection. Which Tableau feature should be used?

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

Correct Answer: 3

Explanation:

A parameter can store a user-selected numeric value and can be referenced by a reference line. By displaying the parameter control, the analyst allows viewers to change the target interactively, and the reference line updates to reflect the selected value. This pattern is useful for adjustable performance thresholds, what-if analysis, and dynamic benchmarks. A group combines dimension members, while data source and extract filters restrict available records. Parameters are especially flexible because they are independent workbook variables that can drive calculations, filters, titles, reference lines, and other analytical behavior when properly configured.

Question 120.

A dashboard contains a map and a detailed bar chart. The analyst wants clicking a region on the map to remove all unrelated bars from the target chart. Which dashboard feature is most appropriate?

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

Correct Answer: 4

Explanation:

A filter action passes values from selected marks in a source worksheet to one or more target worksheets and restricts the target data accordingly. Selecting a region on a map can therefore cause the bar chart to display only values associated with that region. This differs from a highlight action, which keeps unrelated marks visible but visually de-emphasizes them. A URL action opens an external resource, while a set action changes set membership and is better suited to more advanced interactive comparisons. When the explicit requirement is to remove unrelated data from a target worksheet based on a dashboard selection, a filter action is the appropriate choice.