A large fact table joins a genuinely small dimension. Which supported optimization may reduce unnecessary shuffle when size and semantics permit?

1. Broadcast every large dataset regardless of memory
2. Broadcasting the small side or allowing an appropriate adaptive optimization
3. Collect both complete datasets to the driver first
4. Remove the join condition