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

 

Question 241.

An analyst wants to create a calculation that always returns total Sales at the Region level, even when additional dimensions such as Category and Sub-Category are added to the view. Which calculation is most appropriate?

1. { FIXED [Region] : SUM([Sales]) }
   2. { INCLUDE [Category] : SUM([Sales]) }
   3. RUNNING_SUM(SUM([Sales]))
   4. WINDOW_SUM(SUM([Sales]))

Correct Answer: 1

Explanation:

A FIXED level-of-detail expression calculates the measure at the dimensions explicitly specified in the expression. { FIXED [Region] : SUM([Sales]) } therefore returns Sales aggregated at the Region level, even if Category, Sub-Category, or other dimensions are added to the visualization. This makes FIXED useful when the calculation must remain at a consistent grain. INCLUDE changes the calculation to a finer level relative to the current view, while RUNNING_SUM and WINDOW_SUM are table calculations that operate on already aggregated marks. Analysts should also remember that FIXED LOD expressions interact with filters according to Tableau’s order of operations, with context filters evaluated before the FIXED expression.

Question 242.

A view displays Region only, but the analyst needs to calculate customer-level Sales first and then average those customer totals within each Region. Which LOD expression type is most appropriate?

1. EXCLUDE
   2. INCLUDE
   3. FIXED at workbook level only
   4. INDEX

Correct Answer: 2

Explanation:

An INCLUDE LOD expression adds a dimension to the level of detail used by the calculation even when that dimension is not displayed in the view. The analyst can include Customer ID so Tableau calculates Sales at the customer level and then aggregates those results back to Region. This is useful for metrics such as average customer sales, where the intermediate calculation must occur at a finer grain than the visible worksheet. EXCLUDE removes dimensions from the calculation instead. FIXED can also define a specific grain, but INCLUDE directly expresses the requirement of adding hidden lower-level detail relative to the current visualization. INDEX is a table-calculation function and does not solve the granularity requirement.

Question 243.

A worksheet contains Category and Sub-Category. The analyst wants each Sub-Category mark to display the total Sales for its Category. Which approach is most appropriate?

1. INCLUDE Category
   2. Running Total
   3. EXCLUDE Sub-Category
   4. Rank

Correct Answer: 3

Explanation:

An EXCLUDE LOD expression removes a dimension that is currently present in the view from the level of detail used for the calculation. If Category and Sub-Category are displayed, excluding Sub-Category causes the calculation to operate at the broader Category level. The Category total can then be repeated across its Sub-Category marks for comparison. INCLUDE would add finer detail rather than remove it, while Running Total and Rank are table calculations dependent on the structure of the displayed marks. EXCLUDE is particularly useful when analysts want to compare detailed members with a parent-level metric without removing the detailed dimension from the visualization.

Question 244.

Which Tableau table calculation is best for showing cumulative Sales over a chronological sequence of months?

1. Percent of Total
   2. Difference
   3. Rank
   4. Running Total

Correct Answer: 4

Explanation:

Running Total accumulates a measure as Tableau moves through the addressing dimension. When Month is placed in chronological order and the calculation is configured to compute across Month, each mark displays the sum of the current month and all preceding months in the partition. This is commonly used for year-to-date Sales, cumulative revenue, and progress toward annual goals. Percent of Total calculates relative contribution, Difference shows change from another mark, and Rank assigns an ordering based on value. The analyst should verify the Compute Using setting because an incorrect addressing direction can cause the running total to accumulate across the wrong dimension or reset at an unexpected point.

Question 245.

Which Tableau table-calculation function can retrieve the value of SUM(Sales) from the immediately preceding mark?

1. LOOKUP(SUM([Sales]),-1)
   2. INDEX(SUM([Sales]))
   3. SIZE(SUM([Sales]))
   4. RANK(SUM([Sales]))

Correct Answer: 1

Explanation:

LOOKUP() retrieves the value of an expression from another row in the current table-calculation partition using a relative offset. An offset of -1 refers to the immediately preceding mark, assuming the view is ordered correctly. This makes LOOKUP(SUM([Sales]),-1) useful for previous-period comparisons, custom difference calculations, and month-over-month analysis. INDEX returns the current mark’s sequential position, SIZE returns the number of marks in the partition, and RANK assigns a value-based position. Because LOOKUP depends on the structure of the visualization, the analyst should always verify the partitioning, addressing, and sort order.

Question 246.

Which Tableau function should an analyst use to calculate the number of unique Order IDs in a view?

1. COUNT()
   2. COUNTD()
   3. SUM()
   4. ATTR()

Correct Answer: 2

Explanation:

COUNTD() returns the number of distinct values in a field. If one Order ID appears across several line-item rows, COUNTD([Order ID]) counts that order only once. This makes it useful for calculating unique orders, customers, products, transactions, or other identifiers. COUNT() counts non-null occurrences and could count the same Order ID several times. SUM() adds numeric values, while ATTR() returns a common value only when the underlying records agree. Understanding the difference between COUNT and COUNTD is important because transactional datasets often contain multiple rows per business entity, and using the wrong aggregation can significantly overstate counts.

Question 247.

What does the ATTR() aggregation display when multiple different values exist for the underlying records represented by a mark?

1. The largest value
   2. The first value
   3. An asterisk indicating multiple values
   4. Zero

Correct Answer: 3

Explanation:

ATTR() returns the field value when all underlying rows associated with a mark contain the same value. If there is more than one distinct underlying value, Tableau typically displays an asterisk rather than selecting one arbitrary value. This behavior makes ATTR useful when an analyst wants to display a dimension as an aggregated attribute without increasing the view’s level of detail. It is also commonly encountered when working with blended data. ATTR does not calculate the maximum, choose the first value, or substitute zero. The asterisk signals that no single field value uniquely represents all underlying records associated with that mark.

Question 248.

An analyst wants to classify Profit as Positive, Negative, or Zero. Which calculated-field structure is most appropriate?

1. COUNTD()
   2. DATETRUNC()
   3. WINDOW_SUM()
   4. IF / ELSEIF / ELSE logic

Correct Answer: 4

Explanation:

IF, ELSEIF, and ELSE logic is well suited to evaluating several conditional branches. The analyst can test whether Profit is greater than zero, less than zero, or exactly zero and return a corresponding category. This is more appropriate than COUNTD, which counts distinct values, DATETRUNC, which modifies date granularity, or WINDOW_SUM, which performs a table calculation. Conditional calculations are frequently used in Tableau to create business classifications, status labels, threshold categories, and flags. The analyst should also determine whether the classification should operate at the row level or on an aggregated measure such as SUM(Profit), because mixing aggregate and non-aggregate fields can cause calculation errors.

Question 249.

Which Tableau function should an analyst use to test whether a Product Name contains the word Chair anywhere in the string?

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

Correct Answer: 1

Explanation:

CONTAINS() returns TRUE when one string contains another substring anywhere within it. For example, CONTAINS([Product Name], “Chair”) identifies values where the text Chair appears at the beginning, middle, or end of the Product Name. STARTSWITH checks only the beginning of a string, while ENDSWITH checks only the end. LEN returns the total number of characters. CONTAINS is useful for creating classifications, filters, and flags from descriptive text. Analysts should still consider differences in capitalization and data quality when designing string logic, particularly if source values are not standardized.

Question 250.

Which Tableau string function removes whitespace from the beginning and end of a value?

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

Correct Answer: 2

Explanation:

TRIM() removes leading and trailing whitespace from a text value. This is useful when source data contains accidental spaces that may cause apparently identical members to behave as separate categories. For example, East and East can produce inconsistent grouping, filtering, or joins if the extra whitespace is not removed. REPLACE substitutes known text, LOWER normalizes capitalization, and LEFT extracts a specified number of characters from the start of a string. TRIM is therefore one of the simplest Tableau data-cleaning functions and is especially useful with data imported from manually maintained spreadsheets, text files, or poorly standardized source systems.

Question 251.

Which Tableau function should be used to calculate the number of days between Order Date and Ship Date?

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

Correct Answer: 3

Explanation:

DATEDIFF() calculates the difference between two dates using a specified unit such as day, month, quarter, or year. An expression such as DATEDIFF(‘day’,[Order Date],[Ship Date]) can calculate shipping duration in days. DATEADD changes a date by adding or subtracting an interval, while DATETRUNC reduces a date to the beginning of a selected period. DATEPART extracts a particular component from a date. Because the requirement is to measure elapsed date units between two dates, DATEDIFF is the correct function. Analysts should also consider how partial periods and date boundaries affect the interpretation of DATEDIFF results.

Question 252.

Which Tableau function should an analyst use to return the first day of the month that contains Order Date?

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

Correct Answer: 4

Explanation:

DATETRUNC(‘month’,[Order Date]) returns a date value representing the beginning of the month containing the original date. For example, an Order Date of September 26 is converted to September 1 of the same year. This is useful for month-level grouping, comparisons, relationships, and custom calculations. MONTH extracts only the month component, while DATEADD shifts dates and DATEDIFF calculates elapsed intervals. DATETRUNC is particularly valuable when analysts need consistent period-start values while retaining a true date data type rather than reducing the field to a simple month number or name.

Question 253.

An analyst wants to move a date three months into the future. Which Tableau expression is appropriate?

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

Correct Answer: 1

Explanation:

DATEADD() shifts a date by a specified number of units. DATEADD(‘month’,3,[Date]) returns a date three months after the original value. Negative values could be used to move backward instead. DATEDIFF measures the distance between two dates and does not create a shifted date. Simply adding three to the month number would not correctly handle year boundaries and would not return a full date. DATETRUNC rounds dates down to period boundaries. DATEADD is therefore the correct function for calculating renewal dates, future milestones, comparison periods, or other date offsets.

Question 254.

Which Tableau function returns the current date without requiring the current time-of-day value?

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

Correct Answer: 2

Explanation:

TODAY() returns the current date and is useful when time-of-day precision is not required. Analysts can use it to calculate age, days remaining, days overdue, or customer tenure relative to the current calendar date. NOW() returns the current date and time, which is better when hours, minutes, and seconds matter. DATEADD shifts an existing date, while DATEPARSE converts specially formatted text into a date where supported. Choosing TODAY rather than NOW can simplify calculations that are intended to operate at a daily level and avoids introducing unnecessary time components into the result.

Question 255.

An analyst needs to stack rows from twelve monthly tables that have matching columns. Which Tableau operation should be used?

1. Join
   2. Relationship
   3. Union
   4. Blend

Correct Answer: 3

Explanation:

A union appends rows from multiple tables with the same or compatible column structure. If each monthly table contains fields such as Order Date, Product, Customer, and Sales, unioning the twelve tables creates one longer dataset containing records from the entire year. Joins combine columns horizontally according to matching keys, while relationships preserve separate logical tables and allow Tableau to determine how they should be queried. Data blending combines aggregated results from separate data sources. When the data is partitioned across several similarly structured files or tables and needs to be stacked vertically, a union is the appropriate data-combination operation.

Question 256.

Which Tableau join type preserves every record from the left table and only matching records from the right table?

1. Inner join
   2. Right join
   3. Full outer join
   4. Left join

Correct Answer: 4

Explanation:

A left join returns every row from the left table and any matching rows from the right table. If no matching right-side record exists, fields from the right table are returned as null. This is useful when the left table represents the complete population that must be preserved. An inner join keeps only matching records, a right join preserves all rows from the right table, and a full outer join retains unmatched rows from both tables. Analysts should carefully evaluate table grain and join cardinality because even a correct join type can produce duplicated rows if several records on both sides share the same join key.

Question 257.

What is a key advantage of Tableau relationships when combining tables with different levels of detail?

1. Each logical table can preserve its own grain until Tableau determines the required query
   2. All tables are permanently flattened before analysis
   3. Relationships eliminate matching fields
   4. Relationships prevent all duplicated source records automatically

Correct Answer: 1

Explanation:

Relationships operate in Tableau’s logical data model and allow tables to retain separate levels of detail. Tableau generates appropriate queries based on which fields are used in a particular visualization rather than immediately flattening all tables into one physical result. This can reduce aggregation problems that often arise when tables with different granularities are physically joined. Relationships still require correctly defined matching fields and sound data modeling, and they do not magically repair duplicate records within the source. Their primary advantage is preserving logical table structure and allowing Tableau to determine how those tables should interact based on the analytical context.

Question 258.

A large data source changes only once each night, and interactive dashboard performance is more important than second-by-second freshness. Which connection option is often appropriate?

1. Live connection is always required
   2. Tableau extract with an appropriate refresh schedule
   3. Static image only
   4. Manual group

Correct Answer: 2

Explanation:

A Tableau extract can store an optimized snapshot of the source data and often provides strong interactive performance while reducing direct workload on the original system. If the source changes only nightly, the extract can be refreshed on an appropriate schedule so that dashboard users receive sufficiently current information without requiring every interaction to query the source database. A live connection may still be suitable in some environments, but it is not automatically required when real-time freshness is unnecessary. Static images remove interactivity, and groups are unrelated to connection architecture. The appropriate choice depends on freshness needs, source performance, network conditions, and operational requirements.

Question 259.

Which Tableau dashboard action allows a selected mark to provide a new value to a parameter?

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

Correct Answer: 3

Explanation:

A parameter action updates a parameter using a value associated with a selected mark. This enables highly interactive dashboards because the updated parameter can drive calculated fields, reference lines, dynamic titles, thresholds, or metric-selection logic. For example, selecting a Sales mark could update a target parameter used elsewhere in the dashboard. A filter action removes nonmatching data from target sheets, while a highlight action emphasizes related marks without changing a parameter. URL actions navigate to external resources. Parameter actions are therefore the appropriate feature when dashboard interaction must feed a selected value directly into parameter-based logic.

Question 260.

A dashboard should let a user select a Region in one chart and show only matching records in several target worksheets. Which Tableau feature should be configured?

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

Correct Answer: 4

Explanation:

A filter action uses the selected values from a source worksheet to restrict the data shown in one or more target worksheets. Selecting a Region can therefore filter several dashboard views so they display only data associated with that region. The action can be configured to trigger on selection, hover, or menu and can specify exactly which target sheets are affected. A highlight action retains all marks and only emphasizes matching ones, while a set action updates set membership. URL actions open external web resources. When the requirement is to remove unrelated target data based on a dashboard selection, a filter action is the appropriate choice.