Approval and After
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
- 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
- Write your data modeling solution with real code execution
- Get instant feedback and a hire/no-hire decision