Explain the differences between Repartition and Coalesce. When would you use each?
SQLmedium
2
Explain the differences between a Data Lake and a Data Warehouse.
SQLeasy
3
Explain the types of triggers in ADF, including schedule, tumbling window, and event-based triggers.
SQLmedium
4
Write a SQL query to find top 3 earners in each department.
SQLmedium
5
Explain how Adaptive Query Execution changes the economics of Spark tuning. What problems does it solve at runtime, and when might you still need manual intervention (e.g., salting, broadcast hints)?
Spark/Big Datamedium
6
Explain wide vs. narrow transformations and how they drive shuffle cost, failure domains, and pipeline design. When would you intentionally add a wide transformation, and how do you minimize its impact?
Spark/Big Datahard
7
Architecturally, how do Job–Stage–Task boundaries in Spark's execution model impact cluster sizing, shuffle cost, and when would you deliberately collapse or split stages?
Spark/Big Datahard
8
What are the key components of the Spark execution model (Job, Stage, Task)?
Spark/Big Datahard
+16 More Questions with Expert Answers
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.