← 🗄️ 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
COURSES COVERING THIS TOPIC
No lesson covers this one directly yet. These teach the surrounding topic from the beginning.
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 EngineeringSCD Type 2 in Delta Lake: track history with one atomic MERGE.→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 EngineeringTop-N per group in SQL: ROW_NUMBER vs RANK vs DENSE_RANK.→
COMPANIES THAT ASSUME THIS
