Content Engagement Data Model
A hard Data Modeling mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- Data Modeling
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
We run a large social content platform where creators publish posts (text, image, video) and people engage through views, reactions, comments, and shares. Each view carries how long the person watched and each reaction carries its kind (like, love, angry), while a comment can reply to another comment so reply threads nest. A share turns an existing post into a brand-new post of its own, so the model has to trace every reshare back to both the post it came from and the person who reshared it. Design a schema that powers virality, creator-performance, and feed-ranking dashboards, knowing that raw engagement runs to billions of events a day, far too much to scan on every dashboard load.
Summary
Post published. Now measure everything that happens next.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Draw your data model on the schema canvas: tables, keys and relationships
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision