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

Composite models allow mixing Import and DirectQuery storage modes in a single dataset.

Question 2

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

Accepted Answer

TOTALYTD

Answer

TOTALYTD calculates a year-to-date aggregation over a date column.

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

Marking a date table ensures DAX time-intelligence functions work correctly.

Question 4

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

Accepted Answer

Bookmarks

Answer

Bookmarks save the current state of filters, slicers, and visual visibility for later recall.

Question 5

What does incremental refresh primarily improve?

Accepted Answer

Refresh performance by only loading new or changed data

Answer

Incremental refresh reloads only recent partitions instead of the whole dataset, speeding refresh.

Microsoft Power BI Practice Test