Power BI Data Modeling Flashcards
6 cards from real Microsoft Certified Data Analyst Associate practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Power BI Data Modeling flashcards as text
In Power BI, what is a hierarchy used for?
Answer: To group columns into drill-down levels for visual exploration
Hierarchies allow report users to drill down through defined levels (e.g., Year > Quarter > Month) within visuals.
Which Power BI Desktop view is used to manage relationships between tables?
Answer: Model view
Model view displays all tables and their relationships as a diagram, where you can create, edit, and delete relationships.
What happens when you have an ambiguous relationship path between tables in Power BI?
Answer: Power BI requires you to use USERELATIONSHIP in DAX to specify which path to use
Ambiguous paths occur when multiple active relationship routes exist; DAX functions like USERELATIONSHIP allow explicit path selection to resolve ambiguity.
What is the benefit of using a snowflake schema over a star schema in Power BI?
Answer: Reduced data redundancy by normalizing dimension tables
Snowflake schemas normalize dimension tables into sub-dimensions, reducing data redundancy at the cost of more complex joins.
What does the 'Is Hidden' property do when applied to a table or column in Power BI?
Answer: Hides it from the Fields pane in report view but keeps it in the model
Setting 'Is Hidden' to true hides the field from report authors in the Fields pane while keeping it available for calculations and relationships.
Which storage mode should you choose for a large table when you need near-real-time data and cannot refresh frequently?
Answer: DirectQuery
DirectQuery mode queries the source system on each interaction, ensuring near-real-time data without requiring scheduled refreshes.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Passing score, renewal, fees, time limit, score validity, retake fee, exam information · verified Oct 2026
- pearsonvue.com — Test delivery · verified Oct 2026