Question 70
A Power BI team has this requirement: An analyst notices fact-table descriptions being duplicated on each of ten million sales rows. Which approach should it implement?
Explanation
Correct Answer
This directly addresses the stated constraint. Star schema normalization can reduce repeated attributes while maintaining relationships. Confirmation: Fact storage reduces while product descriptions remain accessible through relationships.
Incorrect Answers
A measure evaluated only in aggregated filter context will not store a per-row label. The specific problem here is that keeping long repeating product strings on every fact record wastes compression and complicates maintenance.
Making both competing relationships active between the same table pair creates an ambiguous default path. The specific problem here is that keeping long repeating product strings on every fact record wastes compression and complicates maintenance.
`SUM(Sales[OrderID])` adds identifiers and does not count orders. The specific problem here is that keeping long repeating product strings on every fact record wastes compression and complicates maintenance.