Exam PL-300 Topic 2 Question 402 Discussion
Actual exam question for Microsoft's PL-300 exam
Question #: 402
Topic #: 2
Question #: 402
Topic #: 2
You have a Power BI data model that analyzes product sales ever 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 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?
A one-to-many relationship exists between the tables.
The auto date/time option for the data model 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?
Suggested Answer: A,B Vote an answer
Auto date/time can create a hidden date table for every eligible date column. A single marked date table plus disabling auto date/time reduces those hidden structures while retaining reusable month and quarter attributes.
The correct answers are A (Disable the auto date/time option); B (Create a Date table and select Mark as date table). The technical decision turns on how to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter. Keeping hidden auto date/time tables alongside a marked common Date table adds redundant structures and inconsistent hierarchies. This rationale is anchored to the PL-300 objective " Create a common date table " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date- time | PL-300 objective: " Create a common date table " | Study guide: https://learn.microsoft.com/en-us
/credentials/certifications/resources/study-guides/pl-300
The correct answers are A (Disable the auto date/time option); B (Create a Date table and select Mark as date table). The technical decision turns on how to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter. Keeping hidden auto date/time tables alongside a marked common Date table adds redundant structures and inconsistent hierarchies. This rationale is anchored to the PL-300 objective " Create a common date table " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date- time | PL-300 objective: " Create a common date table " | Study guide: https://learn.microsoft.com/en-us
/credentials/certifications/resources/study-guides/pl-300
by Jay at Aug 16, 2026, 11:29 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).