Question library
Questions from real interviews. Drill any of them by voice in a couple of minutes, with an interviewer, a score and feedback.
What's the difference between a data warehouse and a data lake?JuniorDesign 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-levelDesign an analytical data warehouse for a marketplace: orders, products, sellers, buyers, delivery. How would you model the data, and why that way?Senior