Loan Application Reporting Schema
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're a lending platform. Customers submit loan applications. Our risk team reviews each application and either approves or declines it. Approved applications may or may not result in funded loans, since the customer must accept the offer. The analytics team needs approval rate breakdowns by customer segment. 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