Microsoft Certified Data Analyst Associate Power BI Data Modeling

Question 1

Which relationship cardinality type is most commonly used between fact tables and dimension tables in a star schema?

Accepted Answer

One-to-many

Answer

One-to-one

Answer

Many-to-many

Answer

Many-to-one

Question 2

What is the purpose of setting a column as a 'Key Column' in a Power BI table?

Accepted Answer

To uniquely identify each row in the table

Answer

To sort the table alphabetically

Answer

To create a relationship automatically

Answer

To hide the column from reports

Question 3

In Power BI, what does a bidirectional cross-filter do in a relationship?

Accepted Answer

It allows filters to flow in both directions between tables

Answer

It prevents filters from crossing the relationship

Answer

It creates a many-to-many relationship automatically

Answer

It improves query performance

Question 4

What is a calculated column in Power BI?

Accepted Answer

A column added to a table using a DAX formula evaluated row by row

Answer

A column computed at query time using M code

Answer

A column imported from a SQL view

Answer

A column created by merging two existing columns

Question 5

Which storage mode stores data in the Power BI model and does NOT query the source on every interaction?

Accepted Answer

Import

Answer

DirectQuery

Answer

Live Connection

Answer

Composite

Question 6

What is the role of a 'Role-Playing Dimension' in a Power BI data model?

Accepted Answer

A single dimension table referenced multiple times via inactive relationships for different date contexts

Answer

A dimension used only for row-level security

Answer

A dimension shared across multiple datasets

Answer

A table with multiple primary keys