Social Platform Data Model
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 platform like Instagram. Users create posts with photos or videos, follow other users, and engage through likes and comments. The growth team wants to measure content virality and the product team needs engagement metrics per content type. Design the data 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