Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 45 discussion

Actual exam question from Microsoft's PL-300

Question #: 45
Topic #: 2

You have a Power BI report for the procurement department. The report contains data from the following tables.

There is a one-to-many relationship from Suppliers to LineItems that uses the ID and Supplier ID columns.
The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals.
What should you do?

A. Merge Suppliers and LineItems.
B. Remove the LineItems[Description] column.
C. Remove the rows from LineItems where LineItems[Invoice Date] is before the beginning of last month.
D. Group LineItems by LineItems[Invoice ID] and LineItems[Invoice Date] with a sum of LineItems[Price].

Show Suggested Answer

Suggested Answer: B 🗳️

by David_Zed at Sept. 14, 2022, 9:42 a.m.

Comments

Submit Cancel

scotchtapebunny

Highly Voted 2 years, 7 months ago

Questions like these scare me. Huge description, and such a simple answer, makes me think if there is a trick here. Why Microsoft why!?

upvoted 86 times

jsking

2 years, 6 months ago

Exactly!! Idk why they do this because it makes no sense specially for such silly questions like this. The point is to test the understanding..

upvoted 4 times

AnnaBi

2 years, 3 months ago

OMG it seems like a riddle!!! they do it on purpose to distract the reader

upvoted 4 times

...

GuerreiroJunior

2 years, 6 months ago

hahahahahahahaha its scare me too hahaha why MS why???

upvoted 2 times

...

st418s21

2 years ago

WHY MICROSOFT WHY?!!!!!!!!!!!!! You scare me bro. LOL XD

upvoted 6 times

...

yordiye

2 years, 6 months ago

WHY???? LOL ....so true..it looks like a reading test

upvoted 9 times

...

lukelin08

Highly Voted 2 years, 9 months ago

Selected Answer: B

B is correct

upvoted 21 times

...

jaume

Most Recent 7 months, 4 weeks ago

Selected Answer: B

I was wondering why option C was not also valid answer.... thanks Koalakueh for clarifying it to me!!! LineItems[Invoice Date] is explicitely used to filter third visual but it's implicit in the first visual as we need to report the entire history for each supplier usage, not just the last month and removing all rows dated older than last month would remove part of this history

upvoted 1 times

...

rcaliandro

11 months ago

Selected Answer: B

I agree, we can safely remove the Description because it is not used in the final report

upvoted 1 times

...

livine

11 months, 2 weeks ago

is it possible to pay for certification in Africa and then compose it in Europe?

upvoted 1 times

...

Dsbuff

1 year, 6 months ago

Selected Answer: B

B is correct

upvoted 2 times

...

Koalakueh

1 year, 8 months ago

C is wrong because doing so will remove older rows of [Invoice ID] still needed for the 'Supplier usage by count and usage of invoices'

upvoted 4 times

ElieG

1 year, 7 months ago

EXACTLY.

upvoted 1 times

...

Igetmyrole

1 year, 10 months ago

C is the answer. This option involves filtering out data that is not relevant to the report's time frame. By removing the rows from LineItems that are not within the last calendar month, we can significantly reduce the size of the dataset without affecting the visuals. Other options cannot be answers because: A: Typically increase dataset size. It might even create data redundancy if not done carefully. B. Removing a single column from a table might save some space, but it is unlikely to have a significant impact on the overall dataset size, especially when compared to filtering the data based on the date. D. This option would change the granularity of your data, potentially causing issues with our visuals. it would also likely increase the size of the dataset if we are aggregating data instead of filtering it.

upvoted 1 times

itenginerd

1 year, 9 months ago

The users of the Spend by Supplier Location have no interest in being limited to the last calendar month. They need a much larger time series. You're offering to remove a significant chunk of model data--but that's only appropriate for one of three report consumer groups. B doesn't save a ton of space, but it does so without impacting any reporting group. It's the only viable win from the four options provided.

upvoted 4 times

...

IngoBI

2 years, 2 months ago

Why cant C be correct? The question does not say anything about that we need historical data before the beginning of previous month, or does it?

upvoted 1 times

IngoBI

2 years, 2 months ago

Is it the lack of filter in visual 1 and 2 that implicitly states that we need it?

upvoted 3 times

itenginerd

1 year, 9 months ago

Exactly. One group needs data only from the last month. The other groups need the full time range.

upvoted 1 times

...

Gumis78

1 year, 8 months ago

I also think that removing a whole column will reduce dataset more than removing "some" rows. Also btw. it will take less processing time than reducing number of rows based on some criteria.

upvoted 2 times

...