Data Modeling in Power BI Flashcards
6 cards from real Power BI 778 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Data Modeling in Power BI flashcards as text
What type of schema uses a single fact table connected to multiple dimension tables in Power BI?
Answer: Star schema
A star schema uses one central fact table directly connected to dimension tables, optimizing query performance in Power BI.
Which cardinality setting should you use when one row in Table A matches exactly one row in Table B?
Answer: One-to-one
A one-to-one relationship means each row in Table A has exactly one corresponding row in Table B.
What is the default storage mode for tables in Power BI Desktop?
Answer: Import
Import mode is the default storage mode, which loads data into Power BI's in-memory engine (VertiPaq).
In Power BI, which relationship filter direction allows filters to propagate in both directions between two tables?
Answer: Bidirectional
Bidirectional cross-filter direction allows filters to flow from either table to the other in a relationship.
What tool in Power BI Desktop helps you visualize all table relationships at once?
Answer: Model view
Model view displays all tables and their relationships visually, allowing you to manage the data model.
Which storage mode in Power BI sends queries directly to the source database without caching data?
Answer: DirectQuery
DirectQuery mode sends every query directly to the data source, ensuring real-time data without local caching.
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 — Renewal, retake fee, passing score, exam format, test delivery, fees, time limit, exam information · verified Oct 2026