A financial-services platform runs three workloads on one Snowflake warehouse: a customer-facing acc

A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.

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.

Practice This Problem

Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it automatically.