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-many relationships are the standard in star schema designs, where one dimension record relates to many fact records.

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

Marking a column as a Key Column indicates it uniquely identifies each row, which is important for data integrity and relationships.

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

Bidirectional cross-filtering allows filter context to propagate in both directions across a relationship, enabling more flexible slicing.

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

Calculated columns are defined with DAX and are computed row by row during data refresh, storing results in the model.

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

Import mode loads data into Power BI's in-memory engine, so all queries run against the cached dataset without hitting the source.

Microsoft Certified Data Analyst Associate Practice Test