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

RELATEDTABLE

Answer

FILTER

Answer

EARLIER

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

Schedule refresh

Answer

Manage security roles

Answer

Compress the model

Question 3

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

Accepted Answer

Row-Level Security (RLS)

Answer

Object-Level Security only

Answer

Sensitivity labels

Answer

Bookmarks

Question 4

What does the VertiPaq engine primarily do in Power BI?

Accepted Answer

Compresses and stores imported data in memory

Answer

Renders mobile layouts

Answer

Manages gateways

Answer

Schedules emails

Question 5

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

Accepted Answer

DirectQuery

Answer

Import

Answer

Dual default

Answer

Streaming only

Question 6

What Power BI Service object groups related dashboards and reports for an audience?

Accepted Answer

App

Answer

Tile

Answer

Theme

Answer

Snapshot

Question 7

Which function would you use to iterate row by row and sum an expression?

Accepted Answer

SUMX

Answer

SUM

Answer

COUNT

Answer

AVERAGE