PL-300 · Question #225
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 Supp
Sign in or unlock PL-300 to reveal the answer and full explanation for question #225. The question stem and answer options stay visible for context.
Question
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?
Exhibits
Options
- ARemove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last
- BMerge Suppliers and Uneltems.
- CGroup Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of
- DRemove the Lineitems[Description] column.
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

