What is the major difference between a data lake and a data warehouse?
💡 Model Answer
A data lake stores raw, unstructured or semi‑structured data in its native format (e.g., CSV, JSON, Parquet) and is optimized for storage cost and flexibility. A data warehouse, such as Amazon Redshift, stores structured, curated data in a columnar format optimized for fast analytical queries. The key difference is that a lake is a repository for all data, while a warehouse is a curated subset designed for reporting and BI. Lakes allow schema‑on‑read, whereas warehouses enforce schema‑on‑write.
Sign in to unlock the rest of this answer
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500