Microsoft Power BI Microsoft Power BI 4

Question 1

Which DAX function returns a related value from a table on the one side of a relationship?

Accepted Answer

Answer

RELATED retrieves a value from the one side of a one-to-many relationship.

Question 2

What is the purpose of a drillthrough page in a Power BI report?

Accepted Answer

Show detailed data for a selected item

Answer

Drillthrough pages display detailed context for a specific value the user right-clicks into.

Question 3

Which security feature restricts data rows based on the user viewing the report?

Accepted Answer

Row-Level Security (RLS)

Answer

Row-Level Security filters table rows according to roles assigned to users.

Question 4

What does the VertiPaq engine primarily do in Power BI?

Accepted Answer

Compresses and stores imported data in memory

Answer

VertiPaq is the columnar in-memory engine that compresses imported data for fast queries.

Question 5

Which storage mode keeps queries running against the source without importing data?

Accepted Answer

DirectQuery

Answer

DirectQuery sends queries directly to the source so data is not cached in the model.

Microsoft Power BI Practice Test