Transform and load the data
7 practice questions under this official exam objective (PL-300) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Speeding up refresh of referenced Power Query queries by moving Query1 to a dataflow
Query1 loads customer data and is referenced by three other queries, and refresh of the semantic model is slow; the fix must improve refresh time whil
Why model-level aggregations do not reduce gateway traffic for Import mode
An on-premises data gateway carries full Import refresh data, and the proposed fix of creating aggregations to summarize results is evaluated against
Unpivoting a wide month-year grid into month, year, and amount columns
A CSV previewed in Power Query holds order amounts in a wide month-by-year grid, and the target shape is three columns: month, year, and the order amo
Minimizing effort when reducing a Power Query Date column to just the year
A Date column previewed in Power Query Editor must be reduced to contain only the year, with the least administrative effort, so the question hinges o
Incremental refresh reduces gateway traffic by refreshing only new partitions
In the on-premises gateway scenario, the proposed solution configures incremental refresh on semantic models running in Import storage mode to cut the
Reducing loaded data in Power Query with grouping and column removal
A report on a two-query semantic model underperforms, and Power Query must be used to cut the data volume loaded into the model, with two complementar
Shrinking a Power BI model for monthly transaction totals with a star schema
A semantic model with Date, Account, and Transactions tables must show monthly transaction totals for the current and prior year, follow a star schema