Question 320
A warehouse joins customer events to a small country reference and sees a large unnecessary shuffle. What should the acceptance test demonstrate?
Explanation
Correct Answer
This directly verifies the intended outcome: Physical join strategy should reflect relative table sizes and engine capabilities. The accepted result is: The plan reduces costly data movement without changing correct joined rows.
Incorrect Answers
Oversized broadcast can exhaust memory.
Required dimension attributes disappear.
Row multiplication creates incorrect facts.