Write an SQL query to find duplicate emails in a users table.
SQLmedium
2
Triggers in ADF, especially tumbling window triggers.
SQLmedium
3
What is a window function? Explain with an example.
SQLmedium
4
Write a SQL query to find top 3 earners in each department.
SQLmedium
5
Write a query to find the top three highest-paid employees in each department using window functions.
SQLmedium
6
Write complex SQL queries involving multiple joins, subqueries, and data aggregation logic.
SQLmedium
7
Convert complex SQL (CTEs, window functions, subqueries) to production-grade PySpark. Discuss when to use spark.sql() vs. DataFrame API, and the implications for testability, partitioning, and execution predictability.
Spark/Big Datamedium
8
Design a cost-aware resource strategy for a Databricks workload with spiky and batch jobs. Explain Dynamic Resource Allocation, when to disable it, and how min/max executors and spot instances affect cost and SLAs.
Spark/Big Datahard
+20 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.