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
What is the difference between a measure and a calculated column in Power BI?
Answer: Measures are computed dynamically at query time; calculated columns are computed at refresh and stored
Measures evaluate dynamically based on filter context at query time, while calculated columns are computed during refresh and stored in the model.
In a star schema, what is the purpose of a fact table?
Answer: To store measurable, quantitative data about business events
Fact tables store numeric measurements (like sales amount, quantity) related to business events, referencing dimension tables via foreign keys.
What Power BI feature allows you to define a specific column to sort another column's display order?
Answer: Sort by Column
The 'Sort by Column' feature lets you sort a column (like month name) by a different numeric column (like month number) to achieve correct ordering.
Which Power BI feature allows you to group related tables and measures into logical sections in the model?
Answer: Display folders
Display folders let you organize fields and measures into folders in the Fields pane, improving model usability for report authors.
What is a composite model in Power BI?
Answer: A model that combines Import and DirectQuery tables in the same report
Composite models allow you to mix Import and DirectQuery storage modes in a single Power BI dataset for performance and freshness flexibility.
What does the 'Mark as Date Table' option do in Power BI?
Answer: Tells Power BI to use the table's date column for built-in time intelligence functions
Marking a table as a Date Table disables auto date/time tables and tells Power BI to use the specified date column for time intelligence calculations.
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