← 🗄️ Data & SQL EngineeringNEXT IN DATA & SQL ENGINEERINGPipeline Orchestration and DAGs→
Core
Warehouse vs Lake vs Lakehouse
A warehouse enforces schema-on-write with tight governance and fast SQL; a data lake stores raw files cheaply with schema-on-read and no transactions; a lakehouse puts an open table format (Iceberg or Delta) on object storage to give ACID, time travel, and schema evolution at lake cost. The choice is about cost, governance, and workload, not vendor preference. Applied-AI interviews probe it because candidates conflate the three and cannot say which fits BI versus ML versus streaming ingest.
a free account unlocks the core curriculum tier · no card
RELATED CONCEPTS
PRACTICE THIS IN REAL QUESTIONS
SQL & Data EngineeringCompare Iceberg, Delta Lake, and Hudi. How would you choose an open table format?→SQL & Data EngineeringImplement Slowly Changing Dimension Type 2 history tracking in a Delta lakehouse.→SQL & Data EngineeringGroup a stream of user events into sessions in SQL (30-minute inactivity gap) using window functions.→SQL & Data EngineeringDesign a data pipeline that is safe to re-run: idempotent writes, late data, and exactly-once effects.→SQL & Data EngineeringA Spark job that used to finish in minutes now takes hours. How do you diagnose and fix it?→SQL & Data EngineeringFind the top-N records per group and a running total per group in SQL.→
COMPANIES THAT ASSUME THIS
