CV0-004 Deployment Practice Question
A company is migrating an on-premises Oracle database to Amazon RDS for MySQL. The migration must have minimal downtime and must handle ongoing changes during migration. The schema needs to be converted to MySQL-compatible format. Which combination of AWS services should the team use?
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 AWS Schema Conversion Tool (SCT)
AWS DMS can perform ongoing replication using CDC, and SCT converts schemas between different database engines.
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 SCT alone
Why it's wrong here
AWS SCT converts schema and code only; it performs no data migration or ongoing replication, so it cannot meet the minimal-downtime requirement alone. SCT is tempting because schema conversion is genuinely needed, but it would be correct only alongside DMS for continuous change capture.
- ✓
AWS DMS with AWS Schema Conversion Tool (SCT)
Why this is correct
AWS DMS performs continuous replication using change data capture (CDC) from the Oracle redo logs, satisfying the minimal-downtime and ongoing-changes constraints. AWS SCT converts the Oracle schema to MySQL-compatible DDL, addressing the schema conversion requirement. Together they cover both migration phases without extended outage.
- ✗
AWS DataSync
Why it's wrong here
DataSync transfers files, not relational data, so it cannot replicate ongoing Oracle changes or convert schema to MySQL. It is tempting because DataSync handles large-scale migration of file shares and object stores, and would be correct for moving flat files into S3 or EFS rather than a database.
- ✗
AWS DMS alone
Why it's wrong here
AWS DMS alone replicates data but cannot convert Oracle schemas to MySQL-compatible format; that requires AWS SCT. DMS is tempting because it handles ongoing change data capture for minimal-downtime migrations, and would suffice if the schema were already MySQL-compatible.
About these practice questions
Courseiva writes every CV0-004 question from scratch — 834 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.