Microsoft Power BI Power BI Data Modeling

Question 1

In Power BI, what type of relationship allows you to filter in both directions between two tables?

Accepted Answer

Bidirectional cross-filter

Answer

Bidirectional cross-filter relationships allow filters to propagate in both directions between related tables.

Question 2

Which cardinality type is recommended as a best practice for most relationships in Power BI data models?

Accepted Answer

One-to-many

Answer

One-to-many is the recommended cardinality because it follows star schema design principles and provides the best performance.

Question 3

What is a star schema in Power BI data modeling?

Accepted Answer

A central fact table surrounded by dimension tables

Answer

A star schema consists of a central fact table connected to multiple dimension tables, resembling a star shape.

Question 4

In Power BI, what is the purpose of a 'bridge table' in a many-to-many relationship scenario?

Accepted Answer

To resolve many-to-many relationships by breaking them into two one-to-many relationships

Answer

A bridge table resolves many-to-many relationships by acting as an intermediary table, splitting the relationship into two one-to-many links.

Question 5

What does the 'Assume Referential Integrity' option do when enabled on a relationship in Power BI?

Accepted Answer

Allows Power BI to use more efficient INNER JOIN queries instead of OUTER JOINs

Answer

Enabling 'Assume Referential Integrity' tells Power BI to use INNER JOINs instead of OUTER JOINs, improving query performance.

Microsoft Power BI Practice Test