Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 45 discussion

Actual exam question from Microsoft's PL-300

Question #: 45
Topic #: 1

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

Suggested Answer:

by nebeskijahac at Feb. 12, 2025, 11:47 a.m.

Comments

Submit Cancel

BhavnishM

2 months ago

just a short explanation on the answer: to minimize data size you should remove unnecessary columns, since you don't need customer id it is removed storing datetime timezone data type data takes more storage space than splitting it into 2 components and storing it as date and time.

upvoted 3 times

...

e5accfd

2 months ago

Remove the column and split. Answers are correct. The purpose of the related report is to recognize weekly sales so removing Customer ID wouldn't impact the report, but you do need Order ID to recognize the revenue in the right period, which leads to second part, you only need dates to recognize the sales in the appropriate week, I would split the Date column then delete the time column

upvoted 2 times

...

Rilabear

2 months, 1 week ago

1.Change to Binary 2. seperate into date and time text needs more storage than integer, and timezone not needed for second one.

upvoted 1 times

...

4b88f2d

3 months ago

Remove column / Split

upvoted 3 times

...

33148b2

3 months, 1 week ago

Removing duplicates always seems to be the best option. For the second field, deleting the column or duration doesn't make sense, although splitting increases the size of the data is the only applicable option.

upvoted 1 times

Fellow_Commentor

1 month, 1 week ago

Removing Duplicate customer IDs will remove crucial data from the Table, since the same customer can have multiple purchases in the same region. The unique value here is Purchase ID not customer ID. At the same time, we do not know the nature of the content of the customer id field so we cannot convert it to binary either. So the only Option left is removing the column Customer ID altogether.

upvoted 2 times

...

4b88f2d

3 months ago

You can't remove duplicates from a Columna who has only unique values as is CustomerID. So is remove columns for me. And spliting is the only answer with sense in the second part.

upvoted 1 times

...

langarz

3 months, 2 weeks ago

Answers seem not to make sense

upvoted 1 times

...

Zander3

3 months, 2 weeks 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 4 times

...

cevara

3 months, 3 weeks ago

What are we going to get if we remove CustomerID column!?

upvoted 1 times

...

Pitxunet

3 months, 3 weeks ago

It can only be the suggested answer.

upvoted 1 times

...

nebeskijahac

3 months, 3 weeks ago

How does splitting the column into separate date and time columns reduce the model size?

upvoted 1 times

Mi4as

2 months, 2 weeks ago

DateTime columns have high cardinality because each unique timestamp is treated as a distinct value. By splitting the column, you reduce the number of unique values in each column, which lowers cardinality and improves compression.

upvoted 1 times

...

nebeskijahac

3 months, 3 weeks ago

should be: - remove the column - change the data type to Duration (this data type requires less space)

upvoted 1 times

Mats2

3 months, 2 weeks ago

No, splitting the column reduces the cardinality, and is the correct answer.

upvoted 2 times

...