Microsoft Certified Data Analyst Associate Microsoft DA-100 3

Question 1

Which DAX function should you use to create a disconnected slicer table that controls a measure without a direct relationship?

Accepted Answer

SELECTEDVALUE

Answer

SELECTEDVALUE returns the single selected value from a column, enabling measures to respond to slicer selections from an unrelated table.

Question 2

In Power BI Service, what is the function of a 'dataflow'?

Accepted Answer

Provides reusable, cloud-based ETL transformations stored as entities

Answer

Dataflows are self-service data preparation tools in Power BI Service that create reusable Power Query transformations stored as Common Data Model entities.

Question 3

A user complains that a Power BI report is slow when slicing by date. The fact table has 50 million rows in Import mode. What is the FIRST optimization to try?

Accepted Answer

Ensure a separate date dimension table with a one-to-many relationship is used

Answer

A proper date dimension table with a star-schema one-to-many relationship enables VertiPaq to filter the fact table efficiently using column-store compression.

Question 4

Which Power BI feature lets you define reusable Power Query steps that can be called like a function across multiple queries?

Accepted Answer

Power Query function (let…in)

Answer

In Power Query, you can create a function using a let…in expression with parameters, then invoke it from other queries to avoid duplicating transformation logic.

Question 5

In DAX, what is the difference between CALCULATE and CALCULATETABLE?

Accepted Answer

CALCULATE returns a scalar value; CALCULATETABLE returns a table

Answer

CALCULATE evaluates an expression (returning a scalar) in a modified filter context, while CALCULATETABLE evaluates a table expression returning a virtual table.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft DA-100 3