You import a Power BI dataset that contains the following tables:
✑ Date
✑ Product
✑ Product Inventory
The Product Inventory table contains 25 million rows. A sample of the data is shown in the following table.
 
The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using the
ProductKey column.
You need to reduce the size of the data model without losing information.
What should you do?

A. Change Summarization for DateKey to Don't Summarize.

B. Remove the relationship between Date and Product Inventory

C. Change the data type of UnitCost to Integer.

D. Remove MovementDate.








 

Suggested Answer: A

The DateKey and MovementDate columns have the same information. Movementdate can be removed.
Incorrect:
Not C: Integer data type would lose data.

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