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 2 question 45 discussion

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

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 Hide Answer
Suggested Answer: B 🗳️
by David_Zed at Sept. 14, 2022, 9:42 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
scotchtapebunny
Highly Voted 2 years, 5 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, 4 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 ago
OMG it seems like a riddle!!! they do it on purpose to distract the reader
upvoted 4 times
...
...
GuerreiroJunior
2 years, 3 months ago
hahahahahahahaha its scare me too hahaha why MS why???
upvoted 2 times
...
st418s21
1 year, 9 months ago
WHY MICROSOFT WHY?!!!!!!!!!!!!! You scare me bro. LOL XD
upvoted 6 times
...
yordiye
2 years, 3 months ago
WHY???? LOL ....so true..it looks like a reading test
upvoted 8 times
...
...
lukelin08
Highly Voted 2 years, 6 months ago
Selected Answer: B
B is correct
upvoted 21 times
...
jaume
Most Recent 5 months, 1 week 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
8 months, 1 week 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
8 months, 3 weeks ago
is it possible to pay for certification in Africa and then compose it in Europe?
upvoted 1 times
...
Dsbuff
1 year, 4 months ago
Selected Answer: B
B is correct
upvoted 2 times
...
Koalakueh
1 year, 5 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, 4 months ago
EXACTLY.
upvoted 1 times
...
...
Igetmyrole
1 year, 7 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, 7 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
1 year, 11 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
1 year, 11 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, 7 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, 5 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
...
...
Shalaleh
1 year, 11 months ago
Selected Answer: B
There is no need for Description column.
upvoted 3 times
...
UlyUkr
1 year, 12 months ago
Answer is B. D won't work due to the fact the Supplier ID (key column) will be removed as it's not included in the Group by function.
upvoted 7 times
da66a09
1 year ago
correct, without supplier id in the group there will be no way to join to the supplier table.
upvoted 2 times
...
...
RazaTheLegend
2 years ago
Selected Answer: B
Correct answer is B
upvoted 1 times
...
BabaJee
2 years, 3 months ago
Selected Answer: B
B is correct
upvoted 2 times
...
csillag
2 years, 4 months ago
Selected Answer: B
B is correct
upvoted 2 times
...
jboiret
2 years, 4 months ago
Selected Answer: B
Answer B
upvoted 1 times
...
Patrick666
2 years, 4 months ago
B is correct
upvoted 1 times
...
sidyndiaye
2 years, 7 months ago
Agree. the correcte answer is B. If you choose C you will loose the Supplier ID and it is used in the report.
upvoted 7 times
...
Load full discussion...
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