CV0-004 Deployment Practice Question
An organization is migrating a MySQL database to Amazon RDS using AWS DMS. They want to minimize downtime by using ongoing replication from the source. Which DMS feature should they enable to capture changes as they occur on the source database?
⚠ Common exam trap
CV0-004 often tests the difference between full load and CDC; the trap is choosing Full load when the requirement is to capture ongoing changes to minimize downtime.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Change Data Capture (CDC)
Change Data Capture (CDC) in AWS DMS captures ongoing changes from the source database by reading the transaction logs (e.g., binary log for MySQL) and applying them to the target. This enables near-zero downtime migration because after the initial full load, CDC continuously replicates inserts, updates, and deletes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Data validation
Why it's wrong here
Data validation compares rows after load to confirm fidelity; it records no source changes. It suits verifying a completed migration rather than sustaining replication. Ongoing replication depends on reading the source transaction log, which Change data capture enables.
- ✓
Change Data Capture (CDC)
Why this is correct
Change Data Capture reads the source's transaction logs and streams ongoing inserts, updates and deletes to the target, so RDS stays synchronised after the initial full load. This satisfies the requirement to minimise downtime during cutover.
- ✗
Full load
Why it's wrong here
Full load copies existing table rows once at task start and then stops; subsequent source changes are missed. It is correct for a one-off migration where downtime is acceptable. Minimising downtime needs continuous change capture, not a single bulk copy.
- ✗
Schema conversion
Why it's wrong here
Schema conversion translates source DDL to the target engine and runs before migration; it captures no ongoing changes. It is the right choice when moving between dissimilar engines, such as Oracle to PostgreSQL. Change data capture requires the task's Change data capture setting.
Go deeper
Related to this question
About these practice questions
This CV0-004 question is part of Courseiva's 834-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
This CV0-004 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CV0-004 exam.