Power BI 778 Data Modeling in Power BI 3

Question 1

What does a composite model in Power BI allow you to do?

Accepted Answer

Combine Import and DirectQuery tables in a single model

Answer

Composite models allow combining Import mode and DirectQuery mode tables within the same Power BI model.

Question 2

Which feature in Power BI helps avoid accidental many-to-many relationships when using bidirectional filters?

Accepted Answer

Single direction filtering

Answer

Using single direction filtering prevents unintended filter propagation that can create ambiguous many-to-many join behavior.

Question 3

What is the role of a bridge table in Power BI data modeling?

Accepted Answer

To resolve many-to-many relationships between two tables

Answer

A bridge table sits between two tables with a many-to-many relationship, resolving it into two one-to-many relationships.

Question 4

What does 'Dual' storage mode mean for a table in Power BI?

Accepted Answer

The table can act as either Import or DirectQuery depending on the query

Answer

Dual mode allows a table to behave as Import or DirectQuery depending on whether the query requires cached or live data.

Question 5

In Power BI, what is a 'role-playing dimension'?

Accepted Answer

A single dimension table used multiple times with different relationships

Answer

A role-playing dimension is a single table (e.g., a Date table) connected to a fact table multiple times via inactive relationships.

Power BI 778 Practice Test