Design and implement a data model
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.
Counting Product Categories Sold Using DAX CALCULATE
This PL-300 hotspot asks for a DAX measure that counts how many distinct product categories had products sold in a selected period. The correct expres
Supporting Analysis with Multiple Date Foreign Keys in Power BI
This question addresses how to handle multiple date foreign keys (Due, Order, Delivery) in a Power BI data model. It establishes that simply renaming
Which three actions create monthly star-schema totals with minimal model size?
This PL-300 question asks for three actions that produce monthly transaction totals for current and prior years while preserving a star schema and min
Handling role-playing dates in Power BI with one renamed and two calculated date tables
A sales table carries three date foreign keys (Due Date, Order Date, Delivery Date), and the proposed design renames one date table as Due Date and cr
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
Does Removing the Salesperson Table Meet Model1's Size Goal?
In this PL-300 scenario, Model1's Sales fact table already stores both SalespersonID and CityID, so removing the redundant one-column Salesperson dime
Does Removing ProductID Shrink the Model Yet Keep City Analysis?
In this PL-300 model-size scenario, deleting the ProductID column from the one-million-row Sales table removes roughly a million string/integer values