The Endless Thread
A medium Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
We're building an analytics warehouse for a consumer social network where users share photos and video. Users create posts, follow one another one direction at a time, and like posts, and the model has to make a duplicate follow or a repeat like impossible to store on its own, not through application checks. A comment either sits on a post or replies to another comment, so with the growth team tracking virality and the product team tracking engagement per content type, design the warehouse model.
Summary
Follows, likes, replies to replies. It never stops.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your data modeling solution with real code execution
- Get instant feedback and a hire/no-hire decision