Microsoft
PL-300 · Question #452
You have a Power BI semantic model that contains the following data. You need to create a solution that meets the following requirements: - Presents transaction amount totals for each month for the cu
Sign in or unlock PL-300 to reveal the answer and full explanation for question #452. The question stem and answer options stay visible for context.
Submitted by brentm· Apr 18, 2026
Question
You have a Power BI semantic model that contains the following data. You need to create a solution that meets the following requirements:
- Presents transaction amount totals for each month for the current and
prior year
- Follows the star schema modeling approach
- Minimizes the data model size
Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- ACreate one-to-many relationships between the tables.
- BIn the Transactions query, delete the TransactionID column.
- CIn the Date query, group by MonthNumber.
- DIn the Transactions query, group by AccountID and MonthStartDate for TransactionDate.
- EIn the Transactions query, add a column that contains the MonthStartDate value for
- FCreate many-to-many relationships between the tables.
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.