Advanced Tableau Certified Data Analyst
Multiple Choice Questions (MCQs) with
Answers and Explanations for Professional
Certification Exams
1. A Tableau developer wants to ensure that a filter applied on one worksheet automatically
affects all worksheets using the same data source. Which option should be used?
A. Add to Context
B. Show Filter
C. Apply to Selected Worksheets
D. Apply to Worksheets → All Using This Data Source
Explanation: This option propagates the filter to every worksheet connected to the same data
source, ensuring consistent analysis throughout the workbook.
2. Which Tableau calculation returns the running total of sales over time?
A. WINDOW_AVG(SUM([Sales]))
B. INDEX()
C. LOOKUP(SUM([Sales]),0)
D. RUNNING_SUM(SUM([Sales]))
Explanation: RUNNING_SUM() accumulates values sequentially, providing cumulative totals
useful for trend analysis.
3. A data analyst wants to compare sales performance against a benchmark line representing
average sales. Which Tableau feature is most appropriate?
A. Clustering
B. Parameters
C. Sets
D. Reference Lines
, Explanation: Reference lines add contextual benchmarks such as averages, medians, or
constants to visualizations.
4. Which type of Tableau filter is executed after context filters but before dimension filters?
A. Extract Filter
B. Data Source Filter
C. Context Filter
D. Top Filter
Explanation: Top and conditional filters are evaluated after context filters and before regular
dimension filters in Tableau's order of operations.
5. Which level of detail (LOD) expression calculates sales per customer regardless of the
dimensions present in the view?
A. INCLUDE
B. EXCLUDE
C. Table Calculation
D. FIXED
Explanation: FIXED LOD expressions compute values independently of the visualization
dimensions, providing consistent aggregation.
6. A dashboard contains multiple visualizations, and selecting a mark in one chart should
highlight related data in another chart without filtering out values. Which action should
be used?
A. URL Action
B. Parameter Action
C. Filter Action
D. Highlight Action
Explanation: Highlight actions emphasize corresponding marks across views while preserving
all displayed data.
Multiple Choice Questions (MCQs) with
Answers and Explanations for Professional
Certification Exams
1. A Tableau developer wants to ensure that a filter applied on one worksheet automatically
affects all worksheets using the same data source. Which option should be used?
A. Add to Context
B. Show Filter
C. Apply to Selected Worksheets
D. Apply to Worksheets → All Using This Data Source
Explanation: This option propagates the filter to every worksheet connected to the same data
source, ensuring consistent analysis throughout the workbook.
2. Which Tableau calculation returns the running total of sales over time?
A. WINDOW_AVG(SUM([Sales]))
B. INDEX()
C. LOOKUP(SUM([Sales]),0)
D. RUNNING_SUM(SUM([Sales]))
Explanation: RUNNING_SUM() accumulates values sequentially, providing cumulative totals
useful for trend analysis.
3. A data analyst wants to compare sales performance against a benchmark line representing
average sales. Which Tableau feature is most appropriate?
A. Clustering
B. Parameters
C. Sets
D. Reference Lines
, Explanation: Reference lines add contextual benchmarks such as averages, medians, or
constants to visualizations.
4. Which type of Tableau filter is executed after context filters but before dimension filters?
A. Extract Filter
B. Data Source Filter
C. Context Filter
D. Top Filter
Explanation: Top and conditional filters are evaluated after context filters and before regular
dimension filters in Tableau's order of operations.
5. Which level of detail (LOD) expression calculates sales per customer regardless of the
dimensions present in the view?
A. INCLUDE
B. EXCLUDE
C. Table Calculation
D. FIXED
Explanation: FIXED LOD expressions compute values independently of the visualization
dimensions, providing consistent aggregation.
6. A dashboard contains multiple visualizations, and selecting a mark in one chart should
highlight related data in another chart without filtering out values. Which action should
be used?
A. URL Action
B. Parameter Action
C. Filter Action
D. Highlight Action
Explanation: Highlight actions emphasize corresponding marks across views while preserving
all displayed data.
