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

One-to-many

Answer

Many-to-many

Answer

One-to-one

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

Many-to-many

Answer

One-to-one

Answer

Many-to-one

Question 3

What is a star schema in Power BI data modeling?

Accepted Answer

A central fact table surrounded by dimension tables

Answer

A schema with no relationships

Answer

A schema with only calculated columns

Answer

A schema where all tables are flat

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

To store calculated measures

Answer

To improve query performance

Answer

To store hierarchy levels

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

Forces referential integrity checks on every refresh

Answer

Creates automatic calculated columns

Answer

Prevents duplicate rows in fact tables

Question 6

Which tool within Power BI Desktop allows you to define and manage relationships between tables visually?

Accepted Answer

Model View

Answer

Report View

Answer

Data View

Answer

Table View