Microsoft Power BI Flashcards
7 cards from real Microsoft Power BI practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Microsoft Power BI flashcards as text
What is a composite model in Power BI?
Answer: A model combining Import and DirectQuery sources
Composite models allow mixing Import and DirectQuery storage modes in a single dataset.
Which DAX time-intelligence function returns year-to-date totals?
Answer: TOTALYTD
TOTALYTD calculates a year-to-date aggregation over a date column.
What is the benefit of marking a table as a Date table in the model?
Answer: Enables proper time-intelligence calculations
Marking a date table ensures DAX time-intelligence functions work correctly.
Which feature captures a specific report state including filters and visibility?
Answer: Bookmarks
Bookmarks save the current state of filters, slicers, and visual visibility for later recall.
What does incremental refresh primarily improve?
Answer: Refresh performance by only loading new or changed data
Incremental refresh reloads only recent partitions instead of the whole dataset, speeding refresh.
Which Power Query operation combines tables by stacking rows vertically?
Answer: Append
Append queries stack rows from multiple tables into one combined table.
Which Power Query operation combines tables by matching columns like a SQL join?
Answer: Merge
Merge joins tables on matching key columns, similar to a SQL join.