Salesforce Certified Tableau Consultant Practice Questions

Salesforce Certified Tableau Consultant exam preparation

Salesforce Certified Tableau Consultant practice questions in English: 180 questions with explanations. The mock exam has 60 questions and 105 minutes.

Salesforce Certified Tableau Consultant free question 8 / 10 · Domain 3: Design and Troubleshoot Calculations and Workbooks

A Difference From table calculation uses Specific Dimensions, with Month of Order Date and Quarter of Order Date selected and Year of Order Date not selected. How does the calculation run?

  1. It moves through the months of the years in a single pass
  2. It starts over for each quarter of the table
  3. It treats Year as the direction and Month as the partition
  4. It runs through months across quarters and restarts each year
Show the answer and explanation

Answer: D

Why this is correct
With Specific Dimensions you decide which dimensions are for addressing and which for partitioning. The selected dimensions, Month and Quarter of Order Date, are the addressing fields, and the unselected Year of Order Date is the partitioning field. The calculation therefore transforms the difference from each month across all quarters within a year, and it starts over for every year.

Why the other options are wrong
"It moves through the months of the years in a single pass" … That happens when all dimensions are selected, because then the entire table is in scope. Year is not selected here.
"It starts over for each quarter of the table" … Selected dimensions are the addressing fields, which set the direction of the calculation. Unselected dimensions partition it, and Year is the one that is not selected.
"It treats Year as the direction and Month as the partition" … Year is not selected, so it is a partitioning field. The selected Month and Quarter are the addressing fields.

Key points
If all dimensions are selected, the entire table is in scope. The At the level option appears when more than one dimension is addressing.

Go to the Salesforce Certified Tableau Consultant practice app (10 free questions; purchase unlocks all questions)

See the full practice set