GO TO A SECTION

↑ ↓ to navigate · Enter to openExplore all sections →
FDEInterviews logo
← SQL & Data Engineering / 42
hardDatabricksSnowflakePalantir

Your CDC stream replays a batch and a customer issues a GDPR deletion mid-stream. Keep the silver mirror exactly-once and compliant.

CDC design questions usually stop at the happy-path MERGE. This one stress-tests it: an at-least-once stream that double-delivers, hard deletes, soft deletes for audit, and a GDPR erasure that must physically purge even the bronze change log. The guarantees have to compose.

Updated Aug 2026 · Grounded in real Forward Deployed Engineer interview loops and written to a senior-engineer editorial bar.

CDC design questions usually stop at the happy-path MERGE. This one stress-tests it: an at-least-once stream that double-delivers, hard deletes, soft deletes for audit, and a GDPR erasure that must physically purge even the bronze change log. The guarantees have to compose.

20 answers per topic instead of 10, plus saved progress and bookmarks · no cardor unlock all 548 remaining answers · ₹2,000 / $25

Every answer, concept and course, every paper breakdown, all published video lessons, hands-on FDE Lab missions, Premium PDF guides and companion files, the full practice-test bank and work-sample downloads. Referral Premium excludes guide PDFs and their companion files.

6 months · One payment · No auto-renewal

Study alongside free video lessons.

Keep practising

Next in this trackBuild a streaming aggregation with exactly-once output, bounded state, and a defined policy for events that arrive an hour late.PremiumNext in this trackThe customer says the synced orders table 'does not match' their ERP. Show me the queries you run.PremiumNext in this trackFind the users who were active in January but not in February.Premium
DISCUSSION · 0

No comments yet — be the first to share your approach.