#data modeling

7 data modeling interview questions, asked at Meta, Airbnb, Amazon and 3 more companies. Last asked Sep 2026.

Model cumulative booking metrics and first and last booking timesSystem designA data engineering round: design the tables and pipeline that report cumulative booking metrics over time, along with each user's (or listing's) first and last booking time. Cover…
Last asked Sep 2026
Model the data for an ad campaign management systemSystem designDesign the schema behind the advertiser side of an ads business: advertisers, campaigns, ad groups, creatives, targeting, budgets and orders, plus how impressions and spend are…
Last asked Aug 2026
Design a collaboratively edited playlistSystem designSeveral people add, remove and reorder songs in the same playlist at once. Scale is not the point: model the ordered list so reorders are cheap and concurrent edits resolve…
Last asked Jul 2026
Design an event analytics platformSystem designDesign the platform that collects product events from the app and makes them available for analysis. Cover how events are captured and ingested, how they land in the warehouse or…
Last asked Apr 2026
Data model for feed posts and sharesSystem designModel the data behind a social feed where people create posts and share other people's posts. Name the entities (users, posts, shares and so on), design the fact and dimension…
Last asked Dec 2025
Design tables and metrics for product event dataSystem designFor a product feature, define the metrics that show whether it is healthy, then design the event and summary tables that compute them: grain, keys, dimensions, and how the tables…
Last asked Sep 2025
Design a basic task management systemSystem designDesign a simple task management system: users create tasks, assign them, set due dates and statuses, and see their lists. Cover the API, the data model, notifications for due…
Last asked Sep 2025