Spark SQL interview questions

15 real Spark SQL questions from the Big Data bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.

1. What is Catalyst optimizer?

Mid
  1. A.a join that ships a small table to all executors to avoid a shuffle
  2. B.Spark SQL's engine that turns a logical plan into an optimized physical plan
  3. C.DataFrames carry a schema and use Catalyst; RDDs are opaque and optimized manually
  4. D.pushing filters to the scan layer so irrelevant data is skipped
Reveal the answer + AI explanation — free account

3. Which statement is correct?

Mid
  1. A.Catalyst optimizer — pushing filters to the scan layer so irrelevant data is skipped
  2. B.Catalyst optimizer — Spark SQL's engine that turns a logical plan into an optimized physical plan
  3. C.Catalyst optimizer — a join that ships a small table to all executors to avoid a shuffle
  4. D.Catalyst optimizer — Spark 3 runtime re-optimization: coalesce partitions, handle skew, switch joins
Reveal the answer + AI explanation — free account

4. What is Adaptive Query Execution?

Senior
  1. A.Spark 3 runtime re-optimization: coalesce partitions, handle skew, switch joins
  2. B.a join that ships a small table to all executors to avoid a shuffle
  3. C.Spark SQL's engine that turns a logical plan into an optimized physical plan
  4. D.DataFrames carry a schema and use Catalyst; RDDs are opaque and optimized manually
Reveal the answer + AI explanation — free account

6. Which statement is correct?

Senior
  1. A.Adaptive Query Execution — Spark 3 runtime re-optimization: coalesce partitions, handle skew, switch joins
  2. B.Adaptive Query Execution — Spark SQL's engine that turns a logical plan into an optimized physical plan
  3. C.Adaptive Query Execution — DataFrames carry a schema and use Catalyst; RDDs are opaque and optimized manually
  4. D.Adaptive Query Execution — pushing filters to the scan layer so irrelevant data is skipped
Reveal the answer + AI explanation — free account

7. What is broadcast join?

Mid
  1. A.pushing filters to the scan layer so irrelevant data is skipped
  2. B.a join that ships a small table to all executors to avoid a shuffle
  3. C.DataFrames carry a schema and use Catalyst; RDDs are opaque and optimized manually
  4. D.Spark SQL's engine that turns a logical plan into an optimized physical plan
Reveal the answer + AI explanation — free account

9. Which statement is correct?

Mid
  1. A.broadcast join — a join that ships a small table to all executors to avoid a shuffle
  2. B.broadcast join — Spark 3 runtime re-optimization: coalesce partitions, handle skew, switch joins
  3. C.broadcast join — Spark SQL's engine that turns a logical plan into an optimized physical plan
  4. D.broadcast join — pushing filters to the scan layer so irrelevant data is skipped
Reveal the answer + AI explanation — free account

10. What is DataFrame vs RDD?

Junior
  1. A.pushing filters to the scan layer so irrelevant data is skipped
  2. B.Spark 3 runtime re-optimization: coalesce partitions, handle skew, switch joins
  3. C.a join that ships a small table to all executors to avoid a shuffle
  4. D.DataFrames carry a schema and use Catalyst; RDDs are opaque and optimized manually
Reveal the answer + AI explanation — free account

12. Which statement is correct?

Junior
  1. A.DataFrame vs RDD — DataFrames carry a schema and use Catalyst; RDDs are opaque and optimized manually
  2. B.DataFrame vs RDD — Spark 3 runtime re-optimization: coalesce partitions, handle skew, switch joins
  3. C.DataFrame vs RDD — Spark SQL's engine that turns a logical plan into an optimized physical plan
  4. D.DataFrame vs RDD — pushing filters to the scan layer so irrelevant data is skipped
Reveal the answer + AI explanation — free account

13. What is predicate pushdown?

Mid
  1. A.pushing filters to the scan layer so irrelevant data is skipped
  2. B.Spark SQL's engine that turns a logical plan into an optimized physical plan
  3. C.Spark 3 runtime re-optimization: coalesce partitions, handle skew, switch joins
  4. D.DataFrames carry a schema and use Catalyst; RDDs are opaque and optimized manually
Reveal the answer + AI explanation — free account

15. Which statement is correct?

Mid
  1. A.predicate pushdown — a join that ships a small table to all executors to avoid a shuffle
  2. B.predicate pushdown — Spark 3 runtime re-optimization: coalesce partitions, handle skew, switch joins
  3. C.predicate pushdown — pushing filters to the scan layer so irrelevant data is skipped
  4. D.predicate pushdown — Spark SQL's engine that turns a logical plan into an optimized physical plan
Reveal the answer + AI explanation — free account

Free to start

Answers, AI explanations, and a scored voice mock interview

Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.

Practice Spark SQL free