Microsoft Certified Data Analyst Associate Microsoft DA-100 4

Question 1

In Power BI, Row-Level Security (RLS) is defined using which language?

Accepted Answer

DAX filter expressions

Answer

RLS roles are defined with DAX filter expressions that restrict which rows a given role can see in each table.

Question 2

What does 'query folding' mean in Power Query?

Accepted Answer

Power Query translating M transformations into native data source queries (e.g., SQL)

Answer

Query folding occurs when Power Query pushes transformation logic back to the data source as a native query, reducing data transfer and improving performance.

Question 3

A report needs a measure that resets the running total at the start of each fiscal year. Which DAX pattern is most appropriate?

Accepted Answer

Use CALCULATE with DATESYTD and specify the year-end date string

Answer

CALCULATE combined with DATESYTD('', '') produces a year-to-date running total that resets at the specified fiscal year end.

Question 4

Which Power BI Service role allows a user to publish reports to a workspace but not change workspace settings or add members?

Accepted Answer

Contributor

Answer

The Contributor role can add, edit, and delete content (including publishing reports) in a workspace but cannot manage workspace access or settings.

Question 5

In Power BI, what is a 'composite model'?

Accepted Answer

A dataset that mixes Import, DirectQuery, and/or Dual storage modes in the same model

Answer

A composite model allows tables within a single Power BI dataset to use different storage modes (Import, DirectQuery, or Dual), combining the benefits of each.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft DA-100 4