Data Modeling Interview Questions

Review this list of 9 data modeling interview questions and answers verified by hiring managers and candidates.

+ Add interview

Product

Engineering

Operations

Design

Marketing

Data

Sales

Finance

Consulting

Add interview

Data Engineer

Asked at Databricks, DoorDash • 4 months ago
Design a database schema for a fitness app.
Data Engineer
Data Modeling
3 answers I was asked this
"user table - with userid, username, email, phonenumber, accountcreateddate exercises table - types of exercises - indoor walk, outdoor walk, running, stairs, cycling, swimming etc - exerciseid, exercisetype date table - date, day, month, year - with dateid Session table - userid, sessiondateid(linked to dateid in date table), exerciseid, distance covered, calories spent, starttime, endtime "
Sreeram reddy B. - "user table - with userid, username, email, phonenumber, accountcreateddate exercises table - types of exercises - indoor walk, outdoor walk, running, stairs, cycling, swimming etc - exerciseid, exercisetype date table - date, day, month, year - with dateid Session table - userid, sessiondateid(linked to dateid in date table), exerciseid, distance covered, calories spent, starttime, endtime "See full answer
Data Engineer
Data Modeling
Asked at Amazon • 3 months ago
Create geographic and demographic dashboards for weekly, monthly, and yearly analytics using order data (100M daily records for 5 years) and customer data (1B customers).
Data Engineer
Data Modeling
1 answer I was asked this
"What do all data scientists need to know about how to work with very large datasets? 37 Follow Request Answer More All related (39) Recommended 📷 Corrin Lakeland · Follow , M.S. Data Science, University of St. Thomas, St. Paul (2018)6yData Science consultant and managerUpvoted by[Tom Halloin](https://www.quora"
Hayatu H. - "What do all data scientists need to know about how to work with very large datasets? 37 Follow Request Answer More All related (39) Recommended 📷 Corrin Lakeland · Follow , M.S. Data Science, University of St. Thomas, St. Paul (2018)6yData Science consultant and managerUpvoted by[Tom Halloin](https://www.quora"See full answer
Data Engineer
Data Modeling
Design a data warehouse schema for Instagram.
Data Modeling
Add answer I was asked this
Data Modeling
Design a data warehouse schema for Amazon.
Data Modeling
Add answer I was asked this
Data Modeling
Design a data warehouse schema for Spotify.
Data Modeling
Add answer I was asked this
Data Modeling

🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

Design a Data Warehouse Schema for a Ride-Sharing Service
Data Modeling
1 answer I was asked this
"Firstly, congratulations to both the interviewer and interviewee. This was a great learning experience However, being a Full Stack engineer and I was having the following suggestions around the Data Model - Driver & Approval can be two different tables Approval & Document - Approval can be a tuple of (userid,documentid) - comments against a rejection (marks the document which triggers rejection)In this way we can capture the entire history of approval workflow (initiate/pending/appr"
Nilanjan D. - "Firstly, congratulations to both the interviewer and interviewee. This was a great learning experience However, being a Full Stack engineer and I was having the following suggestions around the Data Model - Driver & Approval can be two different tables Approval & Document - Approval can be a tuple of (userid,documentid) - comments against a rejection (marks the document which triggers rejection)In this way we can capture the entire history of approval workflow (initiate/pending/appr"See full answer
Data Modeling
Design a Data Warehouse Schema for Stripe
Data Modeling
Add answer I was asked this
Data Modeling
Design a Data Warehouse Schema for Airbnb
Data Modeling
Add answer I was asked this
Data Modeling
Design a Data Warehouse Schema for Customer Support
Data Modeling
Add answer I was asked this
Data Modeling