Power BI Data Modeling Flashcards
6 cards from real Microsoft Power BI 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 type of relationship allows you to filter in both directions between two tables?
Answer: Bidirectional cross-filter
Bidirectional cross-filter relationships allow filters to propagate in both directions between related tables.
Which cardinality type is recommended as a best practice for most relationships in Power BI data models?
Answer: One-to-many
One-to-many is the recommended cardinality because it follows star schema design principles and provides the best performance.
What is a star schema in Power BI data modeling?
Answer: A central fact table surrounded by dimension tables
A star schema consists of a central fact table connected to multiple dimension tables, resembling a star shape.
In Power BI, what is the purpose of a 'bridge table' in a many-to-many relationship scenario?
Answer: To resolve many-to-many relationships by breaking them into two one-to-many relationships
A bridge table resolves many-to-many relationships by acting as an intermediary table, splitting the relationship into two one-to-many links.
What does the 'Assume Referential Integrity' option do when enabled on a relationship in Power BI?
Answer: Allows Power BI to use more efficient INNER JOIN queries instead of OUTER JOINs
Enabling 'Assume Referential Integrity' tells Power BI to use INNER JOINs instead of OUTER JOINs, improving query performance.
Which tool within Power BI Desktop allows you to define and manage relationships between tables visually?
Answer: Model View
Model View provides a visual canvas where you can see and manage all table relationships in your data model.