A financial-services platform runs three workloads on one Snowflake warehouse: a customer-facing acc
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 financial-services platform runs three workloads on one Snowflake warehouse: a customer-facing account history view (needs sub-50ms reads), a BI revenue dashboard, and a compliance audit on quarterly historical scans. Two of the three are wrong-shape for Snowflake. Apply the section's multi-layer storage framing and split the workloads onto an operational store, a lakehouse archive (with time travel), and a warehouse mart fed daily from the lakehouse.
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