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
Which relationship cardinality type is most commonly used between fact tables and dimension tables in a star schema?
Answer: One-to-many
One-to-many relationships are the standard in star schema designs, where one dimension record relates to many fact records.
What is the purpose of setting a column as a 'Key Column' in a Power BI table?
Answer: To uniquely identify each row in the table
Marking a column as a Key Column indicates it uniquely identifies each row, which is important for data integrity and relationships.
In Power BI, what does a bidirectional cross-filter do in a relationship?
Answer: It allows filters to flow in both directions between tables
Bidirectional cross-filtering allows filter context to propagate in both directions across a relationship, enabling more flexible slicing.
What is a calculated column in Power BI?
Answer: A column added to a table using a DAX formula evaluated row by row
Calculated columns are defined with DAX and are computed row by row during data refresh, storing results in the model.
Which storage mode stores data in the Power BI model and does NOT query the source on every interaction?
Answer: Import
Import mode loads data into Power BI's in-memory engine, so all queries run against the cached dataset without hitting the source.
What is the role of a 'Role-Playing Dimension' in a Power BI data model?
Answer: A single dimension table referenced multiple times via inactive relationships for different date contexts
Role-playing dimensions allow a single dimension (like Date) to serve multiple roles (e.g., Order Date, Ship Date) using inactive relationships activated by USERELATIONSHIP.
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