ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 45 discussion

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

HOTSPOT
-

You have a Power BI semantic model named Model1 that contains a table named Sales.

Sales contains 10 million records and the following data.



The related report displays the weekly sales per region.

You need to minimize the size of Model1.

How should you modify the CustomerID column and the PurchaseDateTime column? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by nebeskijahac at Feb. 12, 2025, 11:47 a.m.

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
Submit Cancel
langarz
12 hours, 37 minutes ago
Answers seem not to make sense
upvoted 1 times
...
Zander3
1 day, 21 hours ago
Since the report only displays weekly sales per region and doesn't require customer-level detail, you can remove the CustomerID column entirely to reduce model size. For the PurchaseDateTime column, splitting it into separate Date and Time columns lets you keep only the date portion (if that's all that's needed for weekly grouping), thereby minimizing unnecessary data.
upvoted 1 times
...
cevara
1 week ago
What are we going to get if we remove CustomerID column!?
upvoted 1 times
...
Pitxunet
1 week, 1 day ago
It can only be the suggested answer.
upvoted 1 times
...
nebeskijahac
1 week, 1 day ago
How does splitting the column into separate date and time columns reduce the model size?
upvoted 1 times
nebeskijahac
1 week, 1 day ago
should be: - remove the column - change the data type to Duration (this data type requires less space)
upvoted 1 times
Mats2
2 days, 3 hours ago
No, splitting the column reduces the cardinality, and is the correct answer.
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago