PL-300 Model the data Practice Question
You have a table with columns 'Product', 'Category', and 'Sales'. You want to create a hierarchy that allows users to drill down from Category to Product. Which is the correct order to create the hierarchy?
⚠ Common exam trap
Many candidates confuse the drill-down direction, thinking the hierarchy should start with the most detailed level (Product) and end with the aggregated level (Category), but Power BI requires the top-down order from aggregate to detail.
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
✓
Category -> Product
In Power BI, a hierarchy is built from the highest (most aggregated) level to the lowest (most granular) level. To allow drill-down from Category to Product, Category must be the top level and Product the child level. Option C correctly orders Category → Product, enabling users to expand from category-level totals to individual product sales.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Product -> Category -> Sales
Why it's wrong here
This sequence is invalid because it mixes a measure with hierarchy levels and places Product above Category. In Power BI, a hierarchy must consist exclusively of dimension columns ordered from the broadest to the most granular level. Since Category is a higher-level attribute than Product, Product -> Category would represent a drill-up, not a drill-down, and including Sales (a measure) as a level is not permitted because measures are aggregated over hierarchy levels, not used to navigate between them.
- ✗
Product -> Category
Why it's wrong here
This direction reverses the natural drill-down order. In a correctly designed hierarchy, the top level is the highest granularity (Category) and each subsequent level provides more detail (Product). Selecting Product as the first level and Category as the second would force the user to drill upward from product to category, which is the opposite of the intended drill-down workflow. Hierarchies in Power BI are always defined from high-level groupings to low-level details, so this structure would cause the drill-down button to move to a coarser grouping instead of a finer one.
- ✓
Category -> Product
Why this is correct
This is the only arrangement that correctly reflects the relationship between the two attributes and matches Power BI's drill-down semantics. Category is the broader grouping, and Product is the more detailed level, so the hierarchy starts at Category and descends to Product. When a user clicks the drill-down arrow, Power BI moves from the top level (Category) to the next level (Product), revealing the underlying data at the product granularity. This structure also supports roll-up (drill-up) back from Product to Category, which is the standard behavior in matrixes and charts.
- ✗
Sales -> Product -> Category
Why it's wrong here
The first level, Sales, is a numeric measure, not a dimension column, so it cannot be part of a hierarchy. Power BI hierarchies must be built from categorical columns that define grouping levels, such as Category, Subcategory, or Product. Including a measure as a level causes an error or simply makes the hierarchy non-functional, because measures are computed after the hierarchy levels are applied. Additionally, even if Sales were replaced with a valid column, the order would still be reversed, as Category should precede Product for a proper drill-down path.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 524 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft 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 PL-300 exam.