Data Modeling Interview Questions

Review this list of 15 Data Modeling interview questions and answers verified by hiring managers and candidates.

+ Share interview

Hot

New

Share interview

Data Engineer Engineering Manager Software Engineer Machine Learning Engineer

Asked at Databricks, DoorDash • a year ago
Design a database schema for a fitness app.
Data Engineer
Data Modeling
3 answers
"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 "
Anonymous Anteater - "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
Design a data warehouse schema for Instagram.
Data Engineer
Data Modeling
1 answer
Data Engineer
Data Modeling
Design a Data Warehouse Schema for a Ride-Sharing Service
Data Engineer
Data Modeling
3 answers
"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 Engineer
Data Modeling
Asked at Amazon • a year 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
"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
Asked at Apple • 3 months ago
How would you design the new storage system, especially the partitioning, as volume grows from millions of records to hundreds of millions or billions?
Engineering Manager
Data Modeling
+1 more
Add answer
Engineering Manager
Data Modeling
+1 more

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

Design a Data Warehouse Schema for Stripe
Data Engineer
Data Modeling
Add answer
Data Engineer
Data Modeling
Design a data warehouse schema for Spotify.
Data Engineer
Data Modeling
Add answer
Data Engineer
Data Modeling
Design a data warehouse schema for Amazon.
Data Engineer
Data Modeling
Add answer
Data Engineer
Data Modeling
Design a Data Warehouse Schema for Customer Support
Data Engineer
Data Modeling
1 answer
"not able to understand the accent of the candidate"
Akash A. - "not able to understand the accent of the candidate"See full answer
Data Engineer
Data Modeling
Design a Data Warehouse Schema for Airbnb
Data Engineer
Data Modeling
Add answer
Data Engineer
Data Modeling
Asked at Waymo • 7 months ago
Given an organizational hierarchy, how would you model it so I can quickly find a person's direct reports and everyone under their department?
Machine Learning Engineer
Data Modeling
+1 more
Add answer
Machine Learning Engineer
Data Modeling
+1 more
Asked at Netflix • 2 months ago
What data models do you need for an advertiser to start a campaign and show ads to users?
Software Engineer
Data Modeling
+1 more
Add answer
Software Engineer
Data Modeling
+1 more
Asked at Meta • 3 months ago
Design a database schema for a ride sharing app.
Data Engineer
Data Modeling
Add answer
Data Engineer
Data Modeling
Asked at LinkedIn • a year ago
Design a data warehouse schema for LinkedIn.
Data Engineer
Data Modeling
Add answer
Data Engineer
Data Modeling
What is Pyspark?
Data Engineer
Data Modeling
2 answers
"spark is general purpose in memory distributed data processing engine. It offers multiple language APIs to do your task. If we are leveraging python API, we call it pySpark"
Narendra S. - "spark is general purpose in memory distributed data processing engine. It offers multiple language APIs to do your task. If we are leveraging python API, we call it pySpark"See full answer
Data Engineer
Data Modeling