CV0-004 Deployment Practice Question
A company is migrating a large Oracle database (2 TB) from on-premises to AWS RDS for Oracle. They require minimal downtime and need to keep the source database running during migration. Which AWS service should they use to achieve continuous replication?
⚠ Common exam trap
Many exam-takers confuse AWS DataSync or S3 Transfer Acceleration as suitable for database replication, but they lack CDC capabilities and are designed for file or object transfers, not transactional database synchronization.
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 DMS with CDC
AWS DMS with Change Data Capture (CDC) is the correct choice because it enables continuous replication of ongoing changes from the source Oracle database to the target RDS for Oracle instance, allowing the source to remain fully operational during migration. CDC captures incremental changes (inserts, updates, deletes) from the source's redo logs, minimizing downtime to a brief cutover window. This meets the requirement of a 2 TB database with minimal downtime while keeping the source running.
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 DataSync
Why it's wrong here
DataSync copies files and objects on a schedule, not Oracle redo or change streams, so it cannot deliver continuous replication into RDS. It suits migrating file shares or S3 data where periodic batch synchronisation is acceptable.
- ✓
AWS DMS with CDC
Why this is correct
AWS DMS with change data capture continuously replicates ongoing changes from the live Oracle source to RDS, so the source stays running and cutover downtime is limited to final catch-up. Native tools like Data Pump require quiescing the database, which the minimal-downtime constraint rules out.
- ✗
AWS S3 Transfer Acceleration
Why it's wrong here
Transfer Acceleration speeds up HTTP uploads to S3 by routing through edge locations; it does not replicate an Oracle database into RDS. It fits accelerating large object uploads to S3 buckets, not database migration with continuous change capture.
- ✗
AWS Snowball Edge
Why it's wrong here
Snowball Edge physically ships data, so replication stops at cutover rather than running continuously; the source cannot stay live and in sync. It suits one-off bulk transfers of terabytes where downtime is acceptable and network transfer is impractical.
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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.