The Person They Were Then
An easy 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
- easy
- Seniority
- mid
Interview Prompt
We run a messaging app where a user's subscription tier and country both drift over time, and the ad-revenue team needs every past impression to reflect the tier and country the user actually had the moment it fired. Design the schema that lets analysts slice historical ad revenue by the profile state as of each event.
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