nerdexam
Microsoft

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.

Submitted by ashley.k· Apr 18, 2026Prepare the data

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

PL-300 question #225 exhibit 1
PL-300 question #225 exhibit 2

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.

Topics

#Dataset optimization#Data size reduction#Unused columns#Data preparation
Full PL-300 Practice