Explain the differences between Repartition and Coalesce. When would you use each?
SQLmedium
2
Explain the types of triggers in ADF, including schedule, tumbling window, and event-based triggers.
SQLmedium
3
Write a SQL query to find top 3 earners in each department.
SQLmedium
4
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
5
What is the difference between repartition and coalesce in Spark?
Spark/Big Datamedium
6
Check for duplicates in a table.
SQLmedium
+6 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.