PL-300 · Question #452
PL-300 Question #452: Real Exam Question with Answer & Explanation
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.
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.