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].








 

Suggested Answer: B

Remove a column that is not used in the visuals reduces the size of the dataset.
Incorrect:
Not A: Merging the tables would increase the dataset.
Not C: Two of the visuals need historical data.
Not D: Grouping would not affect size.

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.