{"id":23330,"date":"2026-09-28T05:07:15","date_gmt":"2026-09-28T05:07:15","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=23330"},"modified":"2026-09-28T05:07:15","modified_gmt":"2026-09-28T05:07:15","slug":"tableau-tda-c01-practice-test-questions-and-exam-dumps-part6-q101-120","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/tableau-tda-c01-practice-test-questions-and-exam-dumps-part6-q101-120\/","title":{"rendered":"Tableau TDA-C01 Practice Test Questions and Exam Dumps Part6 Q101-120"},"content":{"rendered":"<h2><b>View Full <\/b><a href=\"https:\/\/www.examlabs.com\/tda-c01-exam-dumps\"><b>Tableau TDA-C01 Exam Dumps<\/b><\/a><b> and Practice Test Dumps<\/b><\/h2>\n<p>&nbsp;<\/p>\n<p><b>Question 101.<\/b><\/p>\n<p><b>An analyst wants to create a calculated field that returns <\/b><b>High Profit<\/b><b> when SUM(Profit) exceeds 100,000 and <\/b><b>Standard Profit<\/b><b> otherwise. Which expression is valid?<\/b><\/p>\n<ol>\n<li><b><\/b> <span style=\"font-weight: 400;\">IF SUM([Profit]) &gt; 100000 THEN &#8220;High Profit&#8221; ELSE &#8220;Standard Profit&#8221; END<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b> <span style=\"font-weight: 400;\">SUM(IF [Profit] &gt; 100000)<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b> <span style=\"font-weight: 400;\">IF [Profit] = SUM(100000) THEN &#8220;High Profit&#8221;<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b> <span style=\"font-weight: 400;\">CASE SUM([Profit]) &gt; 100000<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The first expression correctly uses an aggregate measure inside an IF statement. Tableau evaluates <\/span><span style=\"font-weight: 400;\">SUM([Profit])<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 102.<\/b><\/p>\n<p><b>Which Tableau function returns the absolute value of a number?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> ROUND()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> ABS()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> SIGN()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> CEILING()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">ABS()<\/span><span style=\"font-weight: 400;\"> returns the absolute value of a numeric expression, removing any negative sign. For example, <\/span><span style=\"font-weight: 400;\">ABS(-250)<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">ROUND()<\/span><span style=\"font-weight: 400;\"> controls decimal precision, while <\/span><span style=\"font-weight: 400;\">SIGN()<\/span><span style=\"font-weight: 400;\"> identifies whether a number is positive, negative, or zero. <\/span><span style=\"font-weight: 400;\">CEILING()<\/span><span style=\"font-weight: 400;\"> 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, <\/span><span style=\"font-weight: 400;\">ABS()<\/span><span style=\"font-weight: 400;\"> is the appropriate Tableau function.<\/span><\/p>\n<p><b>Question 103.<\/b><\/p>\n<p><b>An analyst wants to round a calculated Profit Ratio to two decimal places. Which Tableau function should be used?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> ABS()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> INT()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> ROUND()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> FLOAT()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The <\/span><span style=\"font-weight: 400;\">ROUND()<\/span><span style=\"font-weight: 400;\"> function rounds a numeric expression to a specified number of decimal places. For example, <\/span><span style=\"font-weight: 400;\">ROUND([Profit Ratio], 2)<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">ABS()<\/span><span style=\"font-weight: 400;\"> returns magnitude, <\/span><span style=\"font-weight: 400;\">INT()<\/span><span style=\"font-weight: 400;\"> converts a number to an integer, and <\/span><span style=\"font-weight: 400;\">FLOAT()<\/span><span style=\"font-weight: 400;\"> converts compatible values to floating-point numbers. For mathematical rounding to a controlled precision, <\/span><span style=\"font-weight: 400;\">ROUND()<\/span><span style=\"font-weight: 400;\"> is appropriate.<\/span><\/p>\n<p><b>Question 104.<\/b><\/p>\n<p><b>Which Tableau function converts a compatible value into an integer?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> STR()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> DATE()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> FLOAT()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> INT()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">INT()<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">FLOAT()<\/span><span style=\"font-weight: 400;\"> converts values to floating-point numbers, <\/span><span style=\"font-weight: 400;\">STR()<\/span><span style=\"font-weight: 400;\"> converts values into strings, and <\/span><span style=\"font-weight: 400;\">DATE()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 105.<\/b><\/p>\n<p><b>Which Tableau function converts a value into text so it can be concatenated with another string in a calculated field?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> STR()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> INT()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> DATEPARSE()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> ATTR()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">STR()<\/span><span style=\"font-weight: 400;\"> 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 <\/span><span style=\"font-weight: 400;\">&#8220;Sales: &#8220;<\/span><span style=\"font-weight: 400;\"> with <\/span><span style=\"font-weight: 400;\">STR(SUM([Sales]))<\/span><span style=\"font-weight: 400;\"> in an appropriate aggregate calculation. Without compatible data types, Tableau may reject the concatenation. <\/span><span style=\"font-weight: 400;\">INT()<\/span><span style=\"font-weight: 400;\"> converts values to integers, while <\/span><span style=\"font-weight: 400;\">DATEPARSE()<\/span><span style=\"font-weight: 400;\"> parses date strings according to a format. <\/span><span style=\"font-weight: 400;\">ATTR()<\/span><span style=\"font-weight: 400;\"> is an aggregation that returns a common value when all underlying rows agree. For general conversion to text, <\/span><span style=\"font-weight: 400;\">STR()<\/span><span style=\"font-weight: 400;\"> is the appropriate function.<\/span><\/p>\n<p><b>Question 106.<\/b><\/p>\n<p><b>Which Tableau function returns the year component of a date as a number?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> DATE()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> YEAR()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> DATETRUNC()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> DATEADD()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">YEAR()<\/span><span style=\"font-weight: 400;\"> extracts the year component from a valid date or datetime value. For example, <\/span><span style=\"font-weight: 400;\">YEAR([Order Date])<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">DATETRUNC()<\/span><span style=\"font-weight: 400;\"> rounds a date down to a specified date boundary, while <\/span><span style=\"font-weight: 400;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> shifts a date by a specified interval. <\/span><span style=\"font-weight: 400;\">DATE()<\/span><span style=\"font-weight: 400;\"> converts compatible expressions into date values. When the requirement is simply to obtain the numeric year component, <\/span><span style=\"font-weight: 400;\">YEAR()<\/span><span style=\"font-weight: 400;\"> is the direct choice.<\/span><\/p>\n<p><b>Question 107.<\/b><\/p>\n<p><b>An analyst needs to add 30 days to an Order Date in a calculated field. Which function should be used?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> DATEDIFF()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> DATETRUNC()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> DATEADD()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> DATEPART()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> adds or subtracts a specified number of date units from a date. A calculation such as <\/span><span style=\"font-weight: 400;\">DATEADD(&#8216;day&#8217;, 30, [Order Date])<\/span><span style=\"font-weight: 400;\"> returns a date 30 days after each Order Date. Negative values can be used to move backward in time. <\/span><span style=\"font-weight: 400;\">DATEDIFF()<\/span><span style=\"font-weight: 400;\"> calculates the difference between two dates, while <\/span><span style=\"font-weight: 400;\">DATETRUNC()<\/span><span style=\"font-weight: 400;\"> truncates a date to a boundary such as the start of a month. <\/span><span style=\"font-weight: 400;\">DATEPART()<\/span><span style=\"font-weight: 400;\"> extracts a component such as month or weekday. When the goal is to shift a date forward or backward by a specified amount, <\/span><span style=\"font-weight: 400;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> is the appropriate function.<\/span><\/p>\n<p><b>Question 108.<\/b><\/p>\n<p><b>Which Tableau function calculates the number of date units between two dates?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> DATEADD()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> DATEPART()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> DATETRUNC()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> DATEDIFF()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">DATEDIFF()<\/span><span style=\"font-weight: 400;\"> returns the difference between two dates in a specified unit such as days, months, quarters, or years. For example, <\/span><span style=\"font-weight: 400;\">DATEDIFF(&#8216;day&#8217;, [Order Date], [Ship Date])<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> changes a date by adding an interval, while <\/span><span style=\"font-weight: 400;\">DATEPART()<\/span><span style=\"font-weight: 400;\"> extracts one component of a date. <\/span><span style=\"font-weight: 400;\">DATETRUNC()<\/span><span style=\"font-weight: 400;\"> reduces a date to the beginning of a specified period. For measuring elapsed date units between two date values, <\/span><span style=\"font-weight: 400;\">DATEDIFF()<\/span><span style=\"font-weight: 400;\"> is the correct function.<\/span><\/p>\n<p><b>Question 109.<\/b><\/p>\n<p><b>Which Tableau function can return the first day of the month containing a given date?<\/b><\/p>\n<ol>\n<li><b><\/b> <span style=\"font-weight: 400;\">DATETRUNC(&#8216;month&#8217;,[Order Date])<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b> <span style=\"font-weight: 400;\">DATEADD(&#8216;month&#8217;,1,[Order Date])<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b> <span style=\"font-weight: 400;\">YEAR([Order Date])<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b> <span style=\"font-weight: 400;\">DATEDIFF(&#8216;month&#8217;,[Order Date],TODAY())<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">DATETRUNC(&#8216;month&#8217;,[Order Date])<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> shifts a date rather than truncating it, while <\/span><span style=\"font-weight: 400;\">YEAR()<\/span><span style=\"font-weight: 400;\"> extracts only the year component. <\/span><span style=\"font-weight: 400;\">DATEDIFF()<\/span><span style=\"font-weight: 400;\"> calculates the number of specified date boundaries between two dates. <\/span><span style=\"font-weight: 400;\">DATETRUNC()<\/span><span style=\"font-weight: 400;\"> is particularly valuable when analysts want a true date value representing the start of a month, quarter, week, or year.<\/span><\/p>\n<p><b>Question 110.<\/b><\/p>\n<p><b>Which Tableau function returns the current date without a time component?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> NOW() only<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> TODAY()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> DATEPARSE()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> MAKEDATE() only<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">TODAY()<\/span><span style=\"font-weight: 400;\"> returns the current date. It is useful for calculations such as days since an order, customer age, or whether an expiration date has passed. <\/span><span style=\"font-weight: 400;\">NOW()<\/span><span style=\"font-weight: 400;\"> returns the current date and time, which may be appropriate when time-of-day precision is required. <\/span><span style=\"font-weight: 400;\">DATEPARSE()<\/span><span style=\"font-weight: 400;\"> converts a date string into a date using a specified pattern, while <\/span><span style=\"font-weight: 400;\">MAKEDATE()<\/span><span style=\"font-weight: 400;\"> constructs a date from separate numeric year, month, and day components. For calculations that need the current calendar date without requiring the current timestamp, <\/span><span style=\"font-weight: 400;\">TODAY()<\/span><span style=\"font-weight: 400;\"> is the most straightforward function.<\/span><\/p>\n<p><b>Question 111.<\/b><\/p>\n<p><b>An analyst wants to display a ratio only when Sales is not zero to avoid division-by-zero errors. Which calculation is most appropriate?<\/b><\/p>\n<ol>\n<li><b><\/b> <span style=\"font-weight: 400;\">SUM([Profit]) \/ SUM([Sales])<\/span><span style=\"font-weight: 400;\"> with no condition<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b> <span style=\"font-weight: 400;\">COUNT([Sales]) \/ SUM([Profit])<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b> <span style=\"font-weight: 400;\">IF SUM([Sales]) &lt;&gt; 0 THEN SUM([Profit]) \/ SUM([Sales]) END<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b> <span style=\"font-weight: 400;\">ZN(SUM([Sales])) \/ SUM([Profit])<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Question 112.<\/b><\/p>\n<p><b>Which Tableau function is commonly used to replace a null numeric expression with zero?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> IFNULL() only<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> ISNULL()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> ATTR()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> ZN()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">ZN()<\/span><span style=\"font-weight: 400;\"> 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 <\/span><span style=\"font-weight: 400;\">IFNULL()<\/span><span style=\"font-weight: 400;\">, which can replace null values with a specified alternative of a compatible type, but <\/span><span style=\"font-weight: 400;\">ZN()<\/span><span style=\"font-weight: 400;\"> is purpose-built for numeric zero replacement. <\/span><span style=\"font-weight: 400;\">ISNULL()<\/span><span style=\"font-weight: 400;\"> only tests whether a value is null and returns a Boolean. <\/span><span style=\"font-weight: 400;\">ATTR()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 113.<\/b><\/p>\n<p><b>What does the IFNULL() function do in Tableau?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Returns a replacement value when the first expression is null<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> Converts every zero to null<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Counts all null records<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Removes null records from the source data<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">IFNULL(expression, replacement)<\/span><span style=\"font-weight: 400;\"> returns the original expression when it is not null and returns the specified replacement when it is null. Unlike <\/span><span style=\"font-weight: 400;\">ZN()<\/span><span style=\"font-weight: 400;\">, which specifically replaces null numeric values with zero, IFNULL can be used with other compatible data types as well. For example, <\/span><span style=\"font-weight: 400;\">IFNULL([Region],&#8221;Unknown&#8221;)<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 114.<\/b><\/p>\n<p><b>An analyst wants a calculation to test whether Product Name begins with the text <\/b><b>Office<\/b><b>. Which Tableau function is most appropriate?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> ENDSWITH()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> STARTSWITH()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> CONTAINS() only<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> FIND() only<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">STARTSWITH()<\/span><span style=\"font-weight: 400;\"> returns true when a string begins with the specified substring. For example, <\/span><span style=\"font-weight: 400;\">STARTSWITH([Product Name], &#8220;Office&#8221;)<\/span><span style=\"font-weight: 400;\"> evaluates whether each Product Name starts with that text. Tableau also provides <\/span><span style=\"font-weight: 400;\">ENDSWITH()<\/span><span style=\"font-weight: 400;\"> for suffix testing and <\/span><span style=\"font-weight: 400;\">CONTAINS()<\/span><span style=\"font-weight: 400;\"> for identifying a substring anywhere within the value. <\/span><span style=\"font-weight: 400;\">FIND()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 115.<\/b><\/p>\n<p><b>Which Tableau function should be used to determine whether a string contains another string anywhere within it?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> LEFT()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> RIGHT()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> CONTAINS()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> TRIM()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">CONTAINS()<\/span><span style=\"font-weight: 400;\"> returns a Boolean value indicating whether one string contains another substring. For example, <\/span><span style=\"font-weight: 400;\">CONTAINS([Product Name], &#8220;Chair&#8221;)<\/span><span style=\"font-weight: 400;\"> identifies product names in which the text <\/span><span style=\"font-weight: 400;\">Chair<\/span><span style=\"font-weight: 400;\"> appears anywhere. This is useful for classification, conditional labeling, and filtering based on text patterns. <\/span><span style=\"font-weight: 400;\">LEFT()<\/span><span style=\"font-weight: 400;\"> and <\/span><span style=\"font-weight: 400;\">RIGHT()<\/span><span style=\"font-weight: 400;\"> return characters from the beginning or end of a string, while <\/span><span style=\"font-weight: 400;\">TRIM()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 116.<\/b><\/p>\n<p><b>Which Tableau function removes leading and trailing spaces from a string?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> REPLACE()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> LOWER()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> UPPER()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> TRIM()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">TRIM()<\/span><span style=\"font-weight: 400;\"> 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, <\/span><span style=\"font-weight: 400;\">&#8220;East&#8221;<\/span><span style=\"font-weight: 400;\"> and <\/span><span style=\"font-weight: 400;\">&#8220;East &#8220;<\/span><span style=\"font-weight: 400;\"> can behave as different values unless the string is cleaned. <\/span><span style=\"font-weight: 400;\">LOWER()<\/span><span style=\"font-weight: 400;\"> and <\/span><span style=\"font-weight: 400;\">UPPER()<\/span><span style=\"font-weight: 400;\"> normalize letter case, while <\/span><span style=\"font-weight: 400;\">REPLACE()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 117.<\/b><\/p>\n<p><b>Which Tableau function converts alphabetic text to uppercase?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> UPPER()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> LOWER()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> TRIM()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> STR()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">UPPER()<\/span><span style=\"font-weight: 400;\"> converts alphabetic characters in a string to uppercase. It is commonly used for normalization when the source contains inconsistent capitalization. For example, <\/span><span style=\"font-weight: 400;\">east<\/span><span style=\"font-weight: 400;\">, <\/span><span style=\"font-weight: 400;\">East<\/span><span style=\"font-weight: 400;\">, and <\/span><span style=\"font-weight: 400;\">EAST<\/span><span style=\"font-weight: 400;\"> can all be transformed to <\/span><span style=\"font-weight: 400;\">EAST<\/span><span style=\"font-weight: 400;\"> before further comparison or grouping. <\/span><span style=\"font-weight: 400;\">LOWER()<\/span><span style=\"font-weight: 400;\"> performs the opposite operation, converting text to lowercase. <\/span><span style=\"font-weight: 400;\">TRIM()<\/span><span style=\"font-weight: 400;\"> removes surrounding whitespace, and <\/span><span style=\"font-weight: 400;\">STR()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 118.<\/b><\/p>\n<p><b>Which Tableau function returns a specified number of characters from the left side of a string?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> MID()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> LEFT()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> RIGHT()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> LEN()<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 2<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">LEFT(string, number)<\/span><span style=\"font-weight: 400;\"> returns the specified number of characters from the beginning of a string. For example, <\/span><span style=\"font-weight: 400;\">LEFT([Product Code],3)<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">RIGHT()<\/span><span style=\"font-weight: 400;\"> retrieves characters from the end, while <\/span><span style=\"font-weight: 400;\">MID()<\/span><span style=\"font-weight: 400;\"> extracts characters beginning at a specified position. <\/span><span style=\"font-weight: 400;\">LEN()<\/span><span style=\"font-weight: 400;\"> returns the number of characters in a string. When a fixed-length prefix needs to be extracted, LEFT is the appropriate function.<\/span><\/p>\n<p><b>Question 119.<\/b><\/p>\n<p><b>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?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Group<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> Data source filter<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Parameter<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Extract filter<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 3<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Question 120.<\/b><\/p>\n<p><b>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?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Highlight action<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> URL action<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Set action<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Filter action<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: 4<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>View Full Tableau TDA-C01 Exam Dumps and Practice Test Dumps &nbsp; 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? IF SUM([Profit]) &gt; 100000 THEN &#8220;High Profit&#8221; ELSE &#8220;Standard Profit&#8221; END 2. SUM(IF [Profit] &gt; 100000) 3. IF [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/23330"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=23330"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/23330\/revisions"}],"predecessor-version":[{"id":23331,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/23330\/revisions\/23331"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=23330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=23330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=23330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}