Ctrl K
Data Engineer · Junior · Theory

What's the difference between a data warehouse and a data lake?

~4 min by voice

How to approach it

This checks whether the candidate understands the fundamental difference between the two architectures: what is stored and in what form, when the schema is applied, what it's built on and whom it serves. Plus whether they see the risks of a lake and the modern lakehouse compromise.

Have you seen this question in a real interview?
Answers0
Avg. score—
Strong—
Practiced0
Topics
Similar questionsThe company wants to move from a classic data warehouse to a lakehouse on object storage. How would you design such a platform, and what trade-offs do you see compared to a traditional DWH? SeniorDesign an analytical data warehouse for a marketplace: orders, products, sellers, buyers, delivery. How would you model the data, and why that way? SeniorDesign an analytical data warehouse for a mid-sized online store: the data comes from the product Postgres database, a CRM and ad platforms, and the consumers are BI dashboards and analysts. Walk me through how you'd set it all up. Mid-levelA mobile app sends about a billion events a day. Design a system for collecting and storing these events so that analysts can build reports and product dashboards update within a few minutes. Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Sign in to answer

Best with headphones · ~4 min