[Solved] Given this Kafka Connect JDBC source config snippet:{"connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector", "connection.url": "jdbc:mysql://localhost:3306/mydb", "table.whitelist":... | Kafka

Kafka - Connect

Given this Kafka Connect JDBC source config snippet:

{"connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector", "connection.url": "jdbc:mysql://localhost:3306/mydb", "table.whitelist": "users", "mode": "incrementing", "incrementing.column.name": "id"}

What does the 'mode' property 'incrementing' do?

AReads the entire table every time

BDeletes rows with incrementing IDs

CReads only new rows with increasing 'id' values

DUpdates rows based on 'id' column

Step-by-Step Solution

Solution:

Step 1: Understand 'incrementing' mode in JDBC source
This mode reads only new rows where the incrementing column value increases.
Step 2: Match behavior to options
It does not read the whole table or delete rows, but fetches new rows with higher IDs.
Final Answer:
Reads only new rows with increasing 'id' values -> Option C
Quick Check:
Incrementing mode = fetch new rows by increasing ID [OK]

Quick Trick: Incrementing mode fetches new rows by ID [OK]

Common Mistakes:

MISTAKES

Thinking it reads entire table each time
Confusing with update or delete operations

Master "Connect" in Kafka

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More Kafka Quizzes

Given this Kafka Connect JDBC source config snippet:

Step 1: Understand 'incrementing' mode in JDBC source

Step 2: Match behavior to options

Final Answer:

Quick Check:

Want More Practice?