{"id":23334,"date":"2026-09-28T05:07:46","date_gmt":"2026-09-28T05:07:46","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=23334"},"modified":"2026-09-28T05:07:46","modified_gmt":"2026-09-28T05:07:46","slug":"tableau-tda-c01-practice-test-questions-and-exam-dumps-part8-q141-160","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/tableau-tda-c01-practice-test-questions-and-exam-dumps-part8-q141-160\/","title":{"rendered":"Tableau TDA-C01 Practice Test Questions and Exam Dumps Part8 Q141-160"},"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 141.<\/b><\/p>\n<p><b>An analyst wants to show the percentage of total Sales contributed by each Sub-Category within its own Category. Which approach is most appropriate?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Apply Percent of Total to SUM(Sales) and configure the table calculation to compute within each Category<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> Use a FIXED LOD expression at the entire data-source level<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Convert Sales to a discrete dimension<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Apply an extract filter to Sub-Category<\/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;\">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&#8217;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.<\/span><\/p>\n<p><b>Question 142.<\/b><\/p>\n<p><b>Which Tableau feature allows a user to dynamically change the number used in a Top N filter?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Set only<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> Parameter<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Group<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Geographic hierarchy<\/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;\">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 <\/span><span style=\"font-weight: 400;\">Top N<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 143.<\/b><\/p>\n<p><b>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?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Create a union between Sales and the target<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> Use a context filter only<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Create a numeric parameter and a calculated field that compares Sales with the parameter<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Convert Sales to a string<\/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 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 <\/span><span style=\"font-weight: 400;\">Above Target<\/span><span style=\"font-weight: 400;\"> when SUM(Sales) exceeds the selected threshold and <\/span><span style=\"font-weight: 400;\">Below Target<\/span><span style=\"font-weight: 400;\"> 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&#8217;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.<\/span><\/p>\n<p><b>Question 144.<\/b><\/p>\n<p><b>Which Tableau feature should an analyst use to let users choose among several predefined values without directly filtering a source field?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Dimension filter<\/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;\"> Extract filter<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Parameter<\/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 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.<\/span><\/p>\n<p><b>Question 145.<\/b><\/p>\n<p><b>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?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> A CASE expression based on a parameter<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> A geographic role<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> A union<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> A context filter only<\/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;\">A CASE expression can evaluate the selected value of a parameter and return the corresponding measure. For example, when the parameter equals <\/span><span style=\"font-weight: 400;\">Sales<\/span><span style=\"font-weight: 400;\">, the calculated field returns <\/span><span style=\"font-weight: 400;\">[Sales]<\/span><span style=\"font-weight: 400;\">; when it equals <\/span><span style=\"font-weight: 400;\">Profit<\/span><span style=\"font-weight: 400;\">, it returns <\/span><span style=\"font-weight: 400;\">[Profit]<\/span><span style=\"font-weight: 400;\">; 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.<\/span><\/p>\n<p><b>Question 146.<\/b><\/p>\n<p><b>Which Tableau function returns the length of a text string?<\/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;\"> LEN()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> FIND()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> MID()<\/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;\">LEN()<\/span><span style=\"font-weight: 400;\"> returns the number of characters in a string. For example, <\/span><span style=\"font-weight: 400;\">LEN([Customer Name])<\/span><span style=\"font-weight: 400;\"> can be used to determine the length of each customer name. This may be useful for validation, classification, or other string-processing tasks. <\/span><span style=\"font-weight: 400;\">LEFT()<\/span><span style=\"font-weight: 400;\"> returns characters from the beginning of a string, <\/span><span style=\"font-weight: 400;\">MID()<\/span><span style=\"font-weight: 400;\"> returns characters from a specified position, and <\/span><span style=\"font-weight: 400;\">FIND()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 147.<\/b><\/p>\n<p><b>Which Tableau function returns characters from the right side of a string?<\/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;\"> MID()<\/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;\"> FIND()<\/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;\">RIGHT(string, number)<\/span><span style=\"font-weight: 400;\"> returns the specified number of characters from the end of a string. For example, <\/span><span style=\"font-weight: 400;\">RIGHT([Product Code],4)<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">LEFT()<\/span><span style=\"font-weight: 400;\"> extracts from the beginning, while <\/span><span style=\"font-weight: 400;\">MID()<\/span><span style=\"font-weight: 400;\"> extracts from a chosen position. <\/span><span style=\"font-weight: 400;\">FIND()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 148.<\/b><\/p>\n<p><b>An analyst wants to extract three characters beginning at the fifth character of a Product Code. Which Tableau function is most appropriate?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> RIGHT()<\/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;\"> LEN()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> MID()<\/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;\">MID()<\/span><span style=\"font-weight: 400;\"> 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. <\/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;\"> are appropriate when the required characters appear at the beginning or end of the field. <\/span><span style=\"font-weight: 400;\">LEN()<\/span><span style=\"font-weight: 400;\"> only reports the string length. When the analyst needs a substring from an internal fixed position, MID provides the required functionality clearly and efficiently.<\/span><\/p>\n<p><b>Question 149.<\/b><\/p>\n<p><b>Which Tableau function returns the position at which one string first appears inside another string?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> FIND()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> CONTAINS()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> LEN()<\/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: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">FIND()<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">CONTAINS()<\/span><span style=\"font-weight: 400;\"> only indicates whether a substring exists, while <\/span><span style=\"font-weight: 400;\">LEN()<\/span><span style=\"font-weight: 400;\"> returns string length and <\/span><span style=\"font-weight: 400;\">TRIM()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 150.<\/b><\/p>\n<p><b>Which Tableau function should an analyst use to replace one substring with another inside a text field?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> TRIM()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> REPLACE()<\/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;\"> UPPER()<\/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;\">REPLACE()<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">TRIM()<\/span><span style=\"font-weight: 400;\"> removes surrounding spaces, <\/span><span style=\"font-weight: 400;\">RIGHT()<\/span><span style=\"font-weight: 400;\"> extracts characters from the end, and <\/span><span style=\"font-weight: 400;\">UPPER()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 151.<\/b><\/p>\n<p><b>An analyst wants a calculation to return the first non-null value between two compatible fields. Which Tableau function is most appropriate?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> ISNULL()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> ZN()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> IFNULL()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> COUNT()<\/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;\">IFNULL(expression, replacement)<\/span><span style=\"font-weight: 400;\"> 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 <\/span><span style=\"font-weight: 400;\">IFNULL([Primary Phone],[Secondary Phone])<\/span><span style=\"font-weight: 400;\"> can return the primary value when available and fall back to the secondary value otherwise. <\/span><span style=\"font-weight: 400;\">ISNULL()<\/span><span style=\"font-weight: 400;\"> only tests whether a value is null, while <\/span><span style=\"font-weight: 400;\">ZN()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 152.<\/b><\/p>\n<p><b>Which Tableau function evaluates whether an expression is null and returns TRUE or FALSE?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> IFNULL()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> ZN()<\/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;\"> ISNULL()<\/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;\">ISNULL()<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">IFNULL()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 153.<\/b><\/p>\n<p><b>Which Tableau date function returns the month number from a date field?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> MONTH()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> DATEADD()<\/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: 1<\/b><\/p>\n<p><b>Explanation:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">MONTH()<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> changes a date, <\/span><span style=\"font-weight: 400;\">DATETRUNC()<\/span><span style=\"font-weight: 400;\"> truncates a date to a specified boundary, and <\/span><span style=\"font-weight: 400;\">DATEDIFF()<\/span><span style=\"font-weight: 400;\"> measures the distance between two dates. When the requirement is to extract the month component, MONTH is the appropriate function.<\/span><\/p>\n<p><b>Question 154.<\/b><\/p>\n<p><b>An analyst wants to calculate the number of months between Customer Start Date and the current date. Which expression is most appropriate?<\/b><\/p>\n<ol>\n<li><b><\/b> <span style=\"font-weight: 400;\">DATEADD(&#8216;month&#8217;,[Start Date],TODAY())<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b> <span style=\"font-weight: 400;\">DATEDIFF(&#8216;month&#8217;,[Start Date],TODAY())<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b> <span style=\"font-weight: 400;\">DATETRUNC(&#8216;month&#8217;,[Start Date])<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b> <span style=\"font-weight: 400;\">MONTH(TODAY())-[Start Date]<\/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;\">DATEDIFF()<\/span><span style=\"font-weight: 400;\"> calculates the difference between two dates using a specified date unit. <\/span><span style=\"font-weight: 400;\">DATEDIFF(&#8216;month&#8217;,[Start Date],TODAY())<\/span><span style=\"font-weight: 400;\"> therefore returns the number of month boundaries between the customer&#8217;s start date and the current date. This can be used to estimate tenure or duration in months. <\/span><span style=\"font-weight: 400;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> shifts a date rather than calculating elapsed time, while <\/span><span style=\"font-weight: 400;\">DATETRUNC()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 155.<\/b><\/p>\n<p><b>Which Tableau function should be used to move an Order Date one year into the future?<\/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;\"> DATEDIFF()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> DATEPART()<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> YEAR()<\/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;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> modifies a date by adding or subtracting a specified number of date units. For example, <\/span><span style=\"font-weight: 400;\">DATEADD(&#8216;year&#8217;,1,[Order Date])<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">DATEDIFF()<\/span><span style=\"font-weight: 400;\"> measures elapsed date units between two dates, while <\/span><span style=\"font-weight: 400;\">DATEPART()<\/span><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Question 156.<\/b><\/p>\n<p><b>Which Tableau function truncates a date to the beginning of the quarter containing that date?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> DATEPART(&#8216;quarter&#8217;,[Order Date])<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> DATEADD(&#8216;quarter&#8217;,1,[Order Date])<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> DATEDIFF(&#8216;quarter&#8217;,[Order Date],TODAY())<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> DATETRUNC(&#8216;quarter&#8217;,[Order Date])<\/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;\">DATETRUNC(&#8216;quarter&#8217;,[Order Date])<\/span><span style=\"font-weight: 400;\"> 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. <\/span><span style=\"font-weight: 400;\">DATEPART()<\/span><span style=\"font-weight: 400;\"> returns a component such as the quarter number rather than the beginning date. <\/span><span style=\"font-weight: 400;\">DATEADD()<\/span><span style=\"font-weight: 400;\"> shifts dates, and <\/span><span style=\"font-weight: 400;\">DATEDIFF()<\/span><span style=\"font-weight: 400;\"> measures intervals. DATETRUNC is especially useful when analysts want to normalize individual dates to period boundaries such as week, month, quarter, or year.<\/span><\/p>\n<p><b>Question 157.<\/b><\/p>\n<p><b>Which Tableau feature is designed to let users drill from Country to State to City within a map or other visualization?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Hierarchy<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> Set<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Bin<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Parameter<\/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;\">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.<\/span><\/p>\n<p><b>Question 158.<\/b><\/p>\n<p><b>Which Tableau feature allows several members such as New York, New Jersey, and Pennsylvania to be combined into a custom category called Northeast?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Set<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> Group<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Bin<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Parameter<\/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;\">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.<\/span><\/p>\n<p><b>Question 159.<\/b><\/p>\n<p><b>Which Tableau feature should an analyst use to dynamically compare a selected subset of customers with all other customers?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Group only<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>2.<\/b><span style=\"font-weight: 400;\"> Bin<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>3.<\/b><span style=\"font-weight: 400;\"> Set<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Geographic role<\/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 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.<\/span><\/p>\n<p><b>Question 160.<\/b><\/p>\n<p><b>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?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\"> Filter 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;\"> Highlight action<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><b>4.<\/b><span style=\"font-weight: 400;\"> Set 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 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.<\/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 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? Apply Percent of Total to SUM(Sales) and configure the table calculation to compute within each Category 2. Use a [&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\/23334"}],"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=23334"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/23334\/revisions"}],"predecessor-version":[{"id":23335,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/23334\/revisions\/23335"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=23334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=23334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=23334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}