A financial-services SaaS has fct_transactions on Iceberg partitioned by transaction_date and cluste
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 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.
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