A single Postgres operational database has two tables of interest
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 single Postgres operational database has two tables of interest. customers (~2M rows, slowly changing) needs hourly freshness; orders (~500M rows, +10M/day) needs five-minute freshness. The destination is Snowflake. The section's three legitimate strategies: full load + incremental pull (cheapest; no deletes on the incremental side), trigger-based CDC (captures deletes; doubles writes), and log-based CDC with Debezium (low overhead; needs WAL access and slot management). Pick the CDC strategy by adding a strategy-marker node downstream of the database whose name states the chosen strategy per table and the trade-off that drove it (scale, deletes, latency, or team capacity).
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