CV0-004 Deployment Practice Question
A company is migrating a 50 TB on-premises database to AWS RDS MySQL. The migration must have minimal downtime and support ongoing replication during the cutover. The database schema is standard MySQL. Which combination of services should the company use?
⚠ Common exam trap
CV0-004 often tests the distinction between schema conversion (SCT, needed only for heterogeneous migrations) and data replication (DMS/CDC) — candidates pick SCT even when the schema is already the target engine.
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
✓
AWS Database Migration Service (DMS) with Change Data Capture (CDC) replication
AWS DMS with Change Data Capture (CDC) performs the initial full load and then continuously replicates ongoing changes from the source MySQL to RDS MySQL, enabling minimal-downtime cutover. Because the schema is standard MySQL, no schema conversion is needed, and CDC keeps the target in sync until the application is switched over.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
AWS DMS with schema conversion tool to convert to MySQL
Why it's wrong here
Schema Conversion Tool is unnecessary because the schema is already standard MySQL; SCT is used when converting from a different engine such as Oracle or SQL Server. AWS DMS alone handles the homogeneous MySQL-to-RDS migration with ongoing replication, so adding SCT introduces needless conversion work.
- ✓
AWS Database Migration Service (DMS) with Change Data Capture (CDC) replication
Why this is correct
DMS performs the initial full load while Change Data Capture continuously replicates ongoing inserts, updates and deletes from the source MySQL binlog, keeping the target in sync until cutover. This satisfies the minimal-downtime and ongoing-replication constraints for the 50 TB migration.
- ✗
AWS Snowball Edge to transfer database dump, then import to RDS
Why it's wrong here
Snowball Edge moves bulk data offline with no continuous replication, so changes made during the multi-day transfer are lost, forcing extended downtime at cutover. It suits one-off transfers of large datasets where the source can be frozen, not a live 50 TB database needing ongoing synchronisation until switchover.
- ✗
AWS DataSync to transfer database files to S3, then restore to RDS
Why it's wrong here
DataSync copies files to S3 and cannot replicate MySQL transactions; restoring a file-level copy to RDS yields a stale database, so cutover still requires downtime. DataSync is designed for file and object migrations to S3, EFS or FSx, not for database-level change replication into RDS.
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.