PL-300 · Question #256
You import a Power Bl 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…
The correct answer is D. Remove MovementDate. The Product Inventory table already has a DateKey column that establishes a relationship to the Date table. If a separate MovementDate column stores the same date information in a different format (e.g., full datetime), it is fully redundant-all date-based analysis can be done…
Question
You import a Power Bl 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?
Exhibit
Options
- AChange Summarization for DateKey to Don't Summarize.
- BChange the data type of UnitCost to Integer.
- CRemove the relationship between Date and Product Inventory.
- DRemove MovementDate.
How the community answered
(45 responses)- A9% (4)
- B4% (2)
- C11% (5)
- D76% (34)
Explanation
The Product Inventory table already has a DateKey column that establishes a relationship to the Date table. If a separate MovementDate column stores the same date information in a different format (e.g., full datetime), it is fully redundant-all date-based analysis can be done through DateKey and the related Date table. Removing MovementDate eliminates a 25-million-row column without losing any analytical capability, directly reducing model size. Option A (changing Summarization) is a metadata/display setting that does not reduce storage. Option B (Integer for UnitCost) loses decimal precision, which constitutes losing information. Option C (removing the Date relationship) would not reduce data size and would break time-intelligence analysis.
Community Discussion
No community discussion yet for this question.