Approval and After
A medium 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
- medium
- Seniority
- L4
Interview Prompt
We run a consumer lending platform. A customer can apply many times, but each application follows one path: our risk team approves or declines it, an approval produces exactly one offer, and that offer is either accepted (funding a single loan) or left to lapse. Because a customer's credit profile drifts over time, the analytics team wants approval rates broken down by the segment the applicant was in when they applied. Design the data model.
Summary
Approved, declined, or pending. Design the tables that say so.
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