Your question is Implement CDC in Data Ingestion. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Discuss how you would implement Change Data Capture (CDC) in a data ingestion process.
Explain how you would capture inserts, updates, and deletes from a transactional database and deliver them to downstream storage or analytics systems. Address technology selection, ordering and delivery guarantees, schema evolution, deduplication, failure recovery, monitoring, security, and historical backfills. Include how you would validate correctness and prevent CDC processing from affecting the source database.
