A public health-tech company has run on a 1.4 PB Snowflake warehouse plus a separate 6 PB raw S3 lak
A medium 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
- medium
Interview Prompt
A public health-tech company has run on a 1.4 PB Snowflake warehouse plus a separate 6 PB raw S3 lake for four years. Two answers exist for every metric and storage costs grew 4x year over year. The new chief data officer commits to a unified lakehouse architecture. Apply the entire L3 tier so a single lakehouse archive feeds the warehouse mart, ML training, and regulator audits, with the operational app keeping its own store and a compaction job keeping file size in target.
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