Tableau General Practice 3 — Questions and Answers
Question 1: What is a Level of Detail (LOD) expression that computes a value independent of the view's dimensions?
- FIXED (Correct answer)
- INCLUDE
- EXCLUDE
- TOTAL
Correct answer: FIXED
A FIXED LOD computes using only the specified dimensions, ignoring the view level of detail.
Question 2: Which Tableau tool is purpose-built for cleaning and shaping data before analysis?
- Tableau Prep Builder (Correct answer)
- Tableau Reader
- Tableau Public
- Tableau Mobile
Correct answer: Tableau Prep Builder
Tableau Prep Builder provides a visual workflow for cleaning, combining, and shaping data.
Question 3: What kind of filter is applied before aggregation and limits the data brought into the view by a dimension's top members?
- Top N filter (Correct answer)
- Measure filter
- Quick filter
- Context filter only
Correct answer: Top N filter
A Top N filter restricts the view to the highest-ranked members of a dimension.
Question 4: Which join type returns only the rows that have matching keys in both tables?
- Inner join (Correct answer)
- Left join
- Right join
- Full outer join
Correct answer: Inner join
An inner join keeps only rows with matches in both tables.
Question 5: What is the purpose of a context filter in Tableau?
- To create a temporary subset that other filters compute against (Correct answer)
- To change the chart color
- To sort the axis
- To merge data sources
Correct answer: To create a temporary subset that other filters compute against
A context filter produces a filtered dataset that subsequent filters and Top N calculations use as their context.
Question 6: Which storage option imports a snapshot of data into Tableau's columnar engine for faster performance?
- Extract (.hyper) (Correct answer)
- Live connection
- Custom SQL
- Blend
Correct answer: Extract (.hyper)
An extract stores a snapshot in Tableau's high-performance Hyper engine.
Question 7: What does the Pages shelf enable in a worksheet?
- Animating or flipping through views by a field's members (Correct answer)
- Adding a second axis
- Creating calculated fields
- Publishing to Server
Correct answer: Animating or flipping through views by a field's members
The Pages shelf breaks the view into pages you can step through, often used for animation.
Tableau General Practice 3
What is a Level of Detail (LOD) expression that computes a value independent of the view's dimensions?