Data Engineer · Senior · System design

Design an analytical data warehouse for a marketplace: orders, products, sellers, buyers, delivery. How would you model the data, and why that way?

~10 min by voice

How to approach it

They're checking whether you can design an analytical model starting from business questions: identify the business processes, set the grain of the facts, justify star versus snowflake, account for dimension history and the warehouse layers. In other words, whether you can tell an analytical warehouse apart from a copy of the production database.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

data modeling data warehouse

Similar questions

What are slowly changing dimensions, SCDs, and what types do you know? Junior What are a primary key and a foreign key? And how would you model a many-to-many relationship, for example students and courses? Junior In which cases would you deliberately denormalize a database schema, and what's the price you pay for it? Mid-level You're designing a sales data mart for BI. Would you choose a star or a snowflake schema, and how would you decide what one row in the fact table represents? Mid-level You need to keep a history of changes to customer attributes, such as plan, city and segment, in a data warehouse, loading data incrementally once a day. How would you implement a Type 2 SCD, and what pitfalls have you run into? Senior

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.

Best with headphones · ~10 min