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 are stored in the table; calculated columns are not

Answer

Measures use M language; calculated columns use DAX

Answer

There is no functional difference

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

To store descriptive attributes about business entities

Answer

To store lookup values for dropdowns

Answer

To define relationships between dimension tables

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

Conditional formatting

Answer

Data category

Answer

Hierarchy

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

Bookmarks

Answer

Hierarchies

Answer

Perspectives

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

A model that uses only DirectQuery tables

Answer

A model with multiple fact tables

Answer

A model with more than 10 relationships

Question 6

What does the 'Mark as Date Table' option do in Power BI?

Accepted Answer

Tells Power BI to use the table's date column for built-in time intelligence functions

Answer

Automatically creates a date hierarchy

Answer

Enables date filtering in slicers

Answer

Imports a calendar from SharePoint