Databases · Senior · Question 19 of 75

What is change data capture (CDC)?

1Capturing screenshots of database dashboards
✓Correct answer: Streaming row-level changes from the database log (e.g. via logical decoding and Debezium) to other systems like search or analytics
3Periodically exporting the whole table to CSV

Explanation

Reading the log avoids dual writes from the application, which can diverge when one write fails. It pairs well with the outbox pattern.

Further reading

Test yourself

Take the Databases · Senior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.