Thousands of Practices, One Dataset
A hard Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- hard
- Seniority
- L6
Interview Prompt
We operate a cloud-based EHR platform used by thousands of medical practices, and each practice's patient and clinical data is stored in a shared database with tenant isolation enforced at the application layer. Our analytics team needs to run cross-tenant population health analytics and individual practice performance reporting without exposing one practice's data to another. Design the pipeline architecture that supports both use cases with proper tenant isolation.
Summary
Patient records in, operational insights out.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision