TCC Calculations and Expressions

Question 1

Which type of Tableau expression computes a result at a specified dimension level regardless of the filters applied to the current view?

Accepted Answer

FIXED LOD expression

Answer

INCLUDE LOD expression

Answer

EXCLUDE LOD expression

Answer

Running Total table calculation

Question 2

What is the correct Tableau syntax for a FIXED Level of Detail expression that calculates average profit per region?

Accepted Answer

{FIXED [Region] : AVG([Profit])}

Answer

{INCLUDE [Region] : AVG([Profit])}

Answer

{EXCLUDE [Region] : AVG([Profit])}

Answer

AVG(FIXED [Region] : [Profit])

Question 3

Which type of Tableau calculation is executed by the Tableau engine after data has been retrieved from the data source, rather than being pushed to the database?

Accepted Answer

Table calculations

Answer

Data source calculations

Answer

Extract calculations

Answer

Row-level calculations

Question 4

What does the Tableau LOOKUP() table calculation function return?

Accepted Answer

The value of an expression in a target row offset relative to the current row

Answer

A value from a data source record located by primary key

Answer

A string match found within another string field

Answer

A VLOOKUP-style result across blended data sources

Question 5

Which LOD expression type adds a dimension to the view's level of detail for the purpose of a finer-grained computation?

Accepted Answer

INCLUDE

Answer

FIXED

Answer

EXCLUDE

Answer

CONTEXT

Question 6

How does a FIXED LOD expression interact with a standard dimension filter in Tableau's order of operations?

Accepted Answer

FIXED LOD runs before dimension filters are applied

Answer

FIXED LOD runs after dimension filters are applied

Answer

FIXED LOD and dimension filters execute simultaneously

Answer

FIXED LOD respects dimension filters by default without any configuration

Question 7

Which of the following is the most appropriate use case for an EXCLUDE LOD expression in Tableau?

Accepted Answer

Calculating a percent of total that removes a specific dimension from the computation

Answer

Computing sales totals independent of all dashboard filters

Answer

Adding a more granular dimension to the current calculation scope

Answer

Replicating the behavior of a running total across partitions