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

Import data from multiple Excel files only

Answer

Create models with no relationships

Answer

Run Python scripts in the 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

Row-level security

Answer

Assume referential integrity

Answer

Composite keys

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

To store KPIs and targets

Answer

To define row-level security

Answer

To store calculated measures

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

The table is stored in two databases

Answer

The table has two primary keys

Answer

The table exists in both Power BI Desktop and Service

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 dimension table used for user access control

Answer

A dimension that stores user role names

Answer

A dimension that drives row-level security

Question 6

What Power BI feature allows you to group numerical data into ranges for analysis?

Accepted Answer

Binning

Answer

Clustering

Answer

Bucketing

Answer

Partitioning