A regulatory audit consumer needs to reproduce the exact reporting numbers a regulator saw 90 days a

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 regulatory audit consumer needs to reproduce the exact reporting numbers a regulator saw 90 days ago. The curated table is plain Parquet, so the historical state has been overwritten by compaction since then. Apply the section's snapshot-isolation framing and replace the plain Parquet table with a lakehouse format that supports the time-travel capability, retaining at least 90 days of snapshots.

Practice This Problem

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