Microsoft Power BI Microsoft Power BI 5

Question 1

What is a composite model in Power BI?

Accepted Answer

A model combining Import and DirectQuery sources

Answer

A model with only one table

Answer

A model with no relationships

Answer

A model used only on mobile

Question 2

Which DAX time-intelligence function returns year-to-date totals?

Accepted Answer

TOTALYTD

Answer

DATEDIFF

Answer

NOW

Answer

WEEKNUM

Question 3

What is the benefit of marking a table as a Date table in the model?

Accepted Answer

Enables proper time-intelligence calculations

Answer

Reduces file size automatically

Answer

Hides the table from users

Answer

Disables relationships

Question 4

Which feature captures a specific report state including filters and visibility?

Accepted Answer

Bookmarks

Answer

Gateways

Answer

Roles

Answer

Dataflows

Question 5

What does incremental refresh primarily improve?

Accepted Answer

Refresh performance by only loading new or changed data

Answer

Visual rendering speed

Answer

Color theming

Answer

Mobile layout

Question 6

Which Power Query operation combines tables by stacking rows vertically?

Accepted Answer

Append

Answer

Merge

Answer

Pivot

Answer

Group By

Question 7

Which Power Query operation combines tables by matching columns like a SQL join?

Accepted Answer

Merge

Answer

Append

Answer

Transpose

Answer

Unpivot