✅ What is CDC (Change Data Capture) – Concepts & Benefits
✅ CDC Patterns – Log-based, Trigger-based, Query-based
✅ Transactional Logs – Binlog (MySQL), WAL (Postgres), Oplog (MongoDB), SQL Server Transaction Log
✅ Event Streaming vs ETL – How CDC differs from batch ETL
1️⃣ What is Change Data Capture, and why is it better than full-table replication?
2️⃣ Explain log-based CDC vs trigger-based CDC.
3️⃣ How does CDC ensure exactly-once or at-least-once semantics?
✔ Inspect a database binlog or WAL and identify change events.
✔ Compare batch ETL vs CDC-based replication for latency and throughput.
✅ Debezium Connectors – MySQL, Postgres, MongoDB, SQL Server, Oracle
✅ Kafka Connect Integration – How Debezium runs on Kafka Connect
✅ Event Flow – DB → Connector → Kafka Topic → Consumer