Microsoft Certified Data Analyst Associate Power BI Data Modeling 2

Question 1

What is the difference between a measure and a calculated column in Power BI?

Accepted Answer

Measures are computed dynamically at query time; calculated columns are computed at refresh and stored

Answer

Measures evaluate dynamically based on filter context at query time, while calculated columns are computed during refresh and stored in the model.

Question 2

In a star schema, what is the purpose of a fact table?

Accepted Answer

To store measurable, quantitative data about business events

Answer

Fact tables store numeric measurements (like sales amount, quantity) related to business events, referencing dimension tables via foreign keys.

Question 3

What Power BI feature allows you to define a specific column to sort another column's display order?

Accepted Answer

Sort by Column

Answer

The 'Sort by Column' feature lets you sort a column (like month name) by a different numeric column (like month number) to achieve correct ordering.

Question 4

Which Power BI feature allows you to group related tables and measures into logical sections in the model?

Accepted Answer

Display folders

Answer

Display folders let you organize fields and measures into folders in the Fields pane, improving model usability for report authors.

Question 5

What is a composite model in Power BI?

Accepted Answer

A model that combines Import and DirectQuery tables in the same report

Answer

Composite models allow you to mix Import and DirectQuery storage modes in a single Power BI dataset for performance and freshness flexibility.

Microsoft Certified Data Analyst Associate Practice Test