Source Connectors & Debezium CDC — Concept Check
Questions on Source Connectors & Debezium CDC. Source connectors pull data into Kafka from external systems; the Debezium CDC connector captures database changes as Kafka events in real time using DB transaction logs.
Questions in this quiz
8 questions on Source Connectors & Debezium CDC — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A company wants to capture real-time changes from their MySQL database into Kafka with minimal latency. Which approach should they use?
- AJDBC Source connector with polling
- BBatch processing
- CManual SQL queries
- DDebezium CDC connector
2.You are setting up a Debezium MySQL CDC connector. What is a necessary configuration change in MySQL?
- AAdd an updated_at column to tables
- BCreate a full database backup
- CIncrease polling interval
- DEnable binlog with binlog_format=ROW
3.A developer claims that Debezium CDC requires an updated_at column for tracking changes. How do you respond?
- ADebezium does not require an updated_at column
- BOnly if using JDBC Source connector
- CIt's optional but recommended
- DYes, it's necessary for Debezium
4.A team is using JDBC Source connector but notices missed deletes in their data. What could be the issue?
- AMisconfigured timestamp column
- BIncorrect polling interval
- CJDBC Source does not capture deletes
- DDatabase connection issues
5.When deploying a Debezium MySQL connector, why is a replication user required?
- ATo read the binary log for changes
- BTo execute INSERT operations
- CTo perform database backups
- DTo manage Kafka topics
6.A system architect suggests using Debezium for a simple append-only audit log. Is this advisable?
- ANo, Debezium cannot handle append-only logs
- BYes, but only with updated_at columns
- CNo, JDBC Source is simpler for append-only logs
- DYes, Debezium is ideal for this
7.What kind of data does a Debezium event contain after an UPDATE operation?
- AOnly the changed fields
- BOnly the new row state
- CFull before and after row state
- DOnly the old row state
8.A developer believes Debezium CDC connector can horizontally scale within a single connector. Is this true?
- AIt depends on the database size
- BNo, it requires exactly-one-task per connector
- COnly if using multiple connectors
- DYes, it scales with more tasks