PL-300 · Question #272
PL-300 Question #272: Real Exam Question with Answer & Explanation
The correct answer is A: Create a relationship between the Date table and the Sales table.. Marking table as date table will remove built-in connected date tables. As we need only month and quarter, we can reduce Date information in newly created Date table - comparing to built-in date tables our created Date table will be lighter so model size is decreases. https://lea
Question
You have a Power BI data model that analyzes product sales over time. The data model contains the following tables. A one-to-many relationship exists between the tables. The auto date/time option for the data model is enabled. You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
Options
- ACreate a relationship between the Date table and the Sales table.
- BDisable the auto date/time option.
- CCreate a Date table and select Mark as Date Table.
- DDisable the load on the Date table.
- ERemove the relationship between the Product table and the Sales table.
Explanation
Marking table as date table will remove built-in connected date tables. As we need only month and quarter, we can reduce Date information in newly created Date table - comparing to built-in date tables our created Date table will be lighter so model size is decreases. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables
Community Discussion
No community discussion yet for this question.