Your question is Adaptive Query Execution (AQE). Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
What is AQE (Adaptive Query Execution)?
Asked in Interview Round 1 or 2. Spark SQL and engine performance optimizations.
Design how you would explain AQE to a team running large Databricks SQL and Spark jobs, including when it helps, when it can hurt, and how you would validate it in production.