Question 500
A semantic model has two fact tables and needs separate filtering by order date versus inventory snapshot date. What should the acceptance test demonstrate?
Explanation
Correct Answer
This directly verifies the intended outcome: Shared dimensions require meaningful keys and fact-specific grain. The accepted result is: Date slicers filter order and inventory measures in their intended periods.
Incorrect Answers
Snapshots and transactions measure different processes.
Report loses consistent time slicing.
Many-to-many matches multiply rows.