Question 250
A join on a large table causes costly shuffled reads because the data has few distinct matching keys and one side is much smaller. What validation most directly tests the stated objective?
Explanation
Correct Answer
This outcome directly verifies the scenario's required behavior: physical plan evidence identifies whether broadcast eliminates unnecessary data exchange.
Incorrect Answers
Replicating large facts can exhaust executor memory.
Planner estimates can choose the wrong strategy.
Changing join semantics loses matched rows.