Tableau-Desktop-Found Understanding Tableau Concepts Practice Question
A retail analyst is creating a view that shows sales by product category and sub-category. The analyst wants to allow users to drill down from category to sub-category without changing the view structure. Which Tableau feature should the analyst use?
⚠ Common exam trap
Many exam-takers confuse drill-down with filtering or parameter switching; hierarchies are specifically designed for interactive level expansion within a single view.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a hierarchy with Category and Sub-Category, then enable drill-down.
Hierarchies are the built-in Tableau feature for drill-down. By placing Category and Sub-Category in a hierarchy, users can expand and collapse levels directly in the view. This provides an interactive way to explore data without changing the view structure or requiring additional parameters.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a table calculation to compute sales at different levels.
Why it's wrong here
Table calculations can compute values at different levels of detail, but they do not provide an interactive drill-down experience. Users would not be able to click to expand or collapse. The feature is designed for calculations, not for navigation. It does not fulfill the requirement of allowing users to drill down.
- ✗
Use a parameter to switch between Category and Sub-Category.
Why it's wrong here
Parameters can be used to dynamically change the view, but they require additional calculated fields and do not provide the intuitive drill-down interaction. Using a parameter would not allow users to simply click to expand; they would need to select from a parameter control. It is not the standard drill-down feature.
- ✓
Create a hierarchy with Category and Sub-Category, then enable drill-down.
Why this is correct
Hierarchies in Tableau allow users to drill down from a higher level to a lower level within the same view. By creating a hierarchy with Category and Sub-Category, the analyst enables users to expand and collapse levels. This meets the requirement of drilling down without altering the view's structure.
- ✗
Use a set to group categories and sub-categories, then filter.
Why it's wrong here
Sets are used to create subsets of data based on conditions, not to enable hierarchical drill-down. Using a set would not provide the expand/collapse functionality. It would only filter the data to include or exclude certain members, which does not meet the requirement of drilling down within the view.
About these practice questions
Courseiva writes every Tableau-Desktop-Found question from scratch — 126 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.