# A financial-services SaaS has fct_transactions on Iceberg partitioned by transaction_date and cluste

Canonical URL: <https://datadriven.io/problems/a-financial-services-saas-has-fcttransactions-on-iceberg-pa-6008d01a>

Domain: Pipeline Design · Difficulty: medium

## Problem

A financial-services SaaS has fct_transactions on Iceberg partitioned by transaction_date and clustered by customer_id, with 600 days of data. A fraud audit filters by date and a customer-statement query filters by customer_id; both predicates should push down to storage. The canvas has the table and the two consumers but no engine. Apply the section's pushdown framing and add the missing piece so the four pruning levels execute.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/a-financial-services-saas-has-fcttransactions-on-iceberg-pa-6008d01a)
- [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.