Question 260
A warehouse must track daily sales at individual line-item grain but a developer proposes grouping facts by month first. What should the acceptance test demonstrate?
Explanation
Correct Answer
This directly verifies the intended outcome: Define fact grain before aggregation so detail is preserved. The accepted result is: Detailed line counts reconcile and month totals can be derived without losing transactions.
Incorrect Answers
Detail is irretrievably lost.
Customer rows do not encode transaction amounts.
Aggregations double count.