# A financial-services platform runs three workloads on one Snowflake warehouse: a customer-facing acc Canonical URL: Domain: Pipeline Design ยท Difficulty: medium ## Problem 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. ## Related - [All practice problems](https://datadriven.io/problems) - [Mock interview mode](https://datadriven.io/interview/a-financial-services-platform-runs-three-workloads-on-one-sn-a13d4223) - [System Design Interview Questions](https://datadriven.io/data-engineering-system-design) - [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep) - [Daily Challenge](https://datadriven.io/daily) --- Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.