Spark and Databricks Practice Problems

#	Problem	Difficulty
1	Fix the skewed join	Medium
2	Incremental load with watermarks and MERGE	Medium
3	SCD Type 2 with Delta MERGE	Hard
4	Handle extreme data skew with salting	Hard
5	Fix the small files problem	Easy
6	Read the physical plan and fix the query	Medium
7	Diagnose spill from Spark UI metrics and size the executors	Hard
8	Rewrite slow Python UDFs with native functions and pandas UDFs	Medium
9	Partitioning, dynamic partition pruning and caching decisions	Hard
10	Design an end-to-end Databricks lakehouse for a retailer	Hard
11	Debug a nightly job: driver OOM, broadcast timeouts and a stale cache	Hard