thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Change Data Capture (Data Engineering) (CDC)

Identifying and capturing row-level inserts, updates and deletes in a source so only changes are propagated downstream.

Definition

Log-based CDC reads database transaction logs (Debezium, AWS DMS, Google Datastream, SQL Server CDC) with minimal source impact. Other methods use timestamps, triggers or snapshot diffs. CDC feeds MERGE-based upserts and SCD processing.

Exam tip

Log-based CDC has the lowest source impact and captures deletes; timestamp-based CDC misses hard deletes.

Related terms