exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 55 discussion

Actual exam question from Microsoft's PL-300
Question #: 55
Topic #: 2
[All PL-300 Questions]

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.

  • A. Create a relationship between the Date table and the Sales table.
  • B. Disable the auto date/time option.
  • C. Create a Date table and select Mark as Date Table.
  • D. Disable the load on the Date table.
  • E. Remove the relationship between the Product table and the Sales table.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
glenman0202
Highly Voted 2 years ago
Selected Answer: AC
AC is the correct answer. According to https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables, marking a table as a Date Table automatically removes the auto-generated date table.
upvoted 60 times
ajinkya42069
1 year ago
thanks dude ! i didnt knew this i was manually disabling the auto generated date table
upvoted 2 times
...
reignreign03
1 year, 4 months ago
Woah, thanks for sharing!
upvoted 3 times
...
Vijay_Krisin
1 year, 6 months ago
Thank you, learnt something new
upvoted 2 times
...
...
UlyUkr
Highly Voted 1 year, 10 months ago
This is the tricky question. If I could, I would go with A, B and C. As, first, you'll need to create a date table and mark it as the Date Table. Second you'll need to create the relationship between this table and the Sales table. And lastly, you will need to disable auto date and time option, as per this article, it will decrease the model size. Option A and C does not decrease the model size. Marking a table as a Date table does not automatically remove the auto-hierarchies in other tables, which makes your data model bigger, so you DO need to disable the auto date/time option.
upvoted 9 times
539d541
6 months, 3 weeks ago
Yesss dude....my thoughts exactly! I chose B and C as a result, knowing that it would be incomplete without creating the relationship (A)
upvoted 1 times
...
itenginerd
1 year, 5 months ago
That last part is not aligned to what Microsoft says. Per https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables#set-your-own-date-table, "when you mark a table as a date table, Power BI Desktop removes the built-in (automatically created) date table"
upvoted 5 times
...
...
5bf040d
Most Recent 4 days, 6 hours ago
Selected Answer: BC
B.Disable the auto date/time option to prevent Power BI from creating hidden date tables. C.Create a custom Date table and mark it as the Date table for time-based analysis. creating a custom Date table does not automatically disable the auto date/time feature in Power BI. The auto date/time option is a global setting that applies to the entire data model, and it continues to create hidden date tables for every date column in your model unless you explicitly disable it. A. Create a relationship between the Date table and the Sales table: is necessary for analyzing sales over time, but it is not directly related to reducing the size of the data model. It is a standard practice when working with a Date table.
upvoted 1 times
...
0002110
2 weeks ago
Selected Answer: BC
Disabling auto date/time prevents the creation of hidden date tables that increase the model size. Creating a dedicated Date table and marking it as a Date Table ensures that you can still perform time-based analysis without the model size being impacted by unnecessary auto-generated date tables.
upvoted 1 times
...
Mamtha1986
2 weeks, 4 days ago
Selected Answer: BC
In Power BI, if Auto Date/Time is enabled, every Date column (e.g., Order Date, Ship Date, Delivered Date) will automatically generate separate hidden date tables. This increases the model size unnecessarily, especially if there are multiple date columns. Disabling Auto Date/Time (Option B) removes these extra hidden tables and significantly reduces model size. If Auto Date/Time is enabled, Power BI already has hidden date tables, so adding a relationship to another Date table does not reduce size. Only after disabling Auto Date/Time, a custom Date table should be created and linked to Sales for better time intelligence.
upvoted 1 times
...
desibaby09
3 months, 2 weeks ago
Selected Answer: BC
When the auto date/time option is enabled, Power BI automatically generates a hidden date table for each date column in your data model. These hidden tables are used for time-based operations like year, month, and quarter analysis. Creating a Date table and marking it as the "Date Table" ensures that the table is used for time intelligence functions. However, the auto date/time option remains enabled unless you explicitly disable it. If you create your own Date table but do not disable the auto date/time option, Power BI will still generate hidden date tables for all date columns. This increases the size of the data model unnecessarily. Disabling the auto date/time option ensures that only your custom Date table is used, reducing model size and improving performance.
upvoted 1 times
SylUK
3 weeks ago
Based on your conclusion, how will you be able to :" analyze product sales by month and quarter." ? The answer is A and C
upvoted 1 times
...
...
jaume
3 months, 4 weeks ago
Selected Answer: AC
Perfectly explained by ak57: Smaller Model Size: By using a custom date table, you avoid the need for multiple auto-generated date tables that Power BI creates by default for each date column in your dataset, leading to a smaller, more efficient model.
upvoted 2 times
...
uno96
3 months, 4 weeks ago
AB is the right answer because disabling auto date/time helps to reduce the size
upvoted 1 times
...
ec338ed
5 months ago
Selected Answer: BC
BC: When you mark a Date table you don't need to create a relationship to work with DAX time intelligence. Only for filtering you need to create relationships.
upvoted 1 times
...
ak57
6 months, 3 weeks ago
A and C: Smaller Model Size: By using a custom date table, you avoid the need for multiple auto-generated date tables that Power BI creates by default for each date column in your dataset, leading to a smaller, more efficient model.
upvoted 1 times
...
539d541
6 months, 3 weeks ago
Selected Answer: BC
I chose B and C as a result, knowing that it would be incomplete without creating the relationship (A) but choosing B would reduce the model size while still getting halfway to the required analysis stage.
upvoted 1 times
...
rcaliandro
7 months ago
It does make sense B and C, but in order to optimize query performances also B (Disable the auto date/time option) should be correct, right?
upvoted 1 times
rcaliandro
6 months, 4 weeks ago
I changed my mind, in my opinion it is AC
upvoted 1 times
...
...
AZFabio
12 months ago
Selected Answer: AC
Correct
upvoted 1 times
...
erency3
1 year, 1 month ago
The answer is BC, AC will not reduce the model size. BC on the other will reduce the model size since you disable auto date/time, and when you mark the date table as the date table the relationship will become automatic, there is no obligation to connect them to do the analysis.
upvoted 4 times
erency3
1 year, 1 month ago
ok I was wrong, marking as date table will also remove auto created date tables, and the relationship will be clear ( too many date columns)
upvoted 1 times
niceguysfinishlast
7 months, 3 weeks ago
If the auto date/time option remains enabled, Power BI might still create hidden date tables for other date columns, potentially increasing the model size unnecessarily.
upvoted 1 times
...
Mo2011
10 months ago
No it DOES NOT
upvoted 2 times
...
...
...
madyjoe21
1 year, 1 month ago
The questions informs that a one-to-many relationship exists between the tables, so I would go B and C
upvoted 2 times
...
asnygen
1 year, 2 months ago
chatgpt> BC is correct
upvoted 2 times
...
HarryGorya
1 year, 3 months ago
Answer - A & C Creating a Date table and selecting Mark as Date Table will automatically disable the auto date/time option in Power BI. This is because Power BI recognizes the designated Date table as the primary source of date information for the data model. When a Date table is marked as such, Power BI will use the date values from this table for all date-related calculations and visualizations. As a result, the auto date/time option becomes redundant and is automatically disabled to avoid potential conflicts or inconsistencies.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago