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
SCT converts schema but does not migrate data continuously.
- ✓
AWS DMS with AWS Schema Conversion Tool (SCT)
Why this is correct
SCT converts schema, DMS with CDC achieves minimal downtime.
- ✗
AWS DataSync
Why it's wrong here
DataSync is for file data, not databases.
- ✗
AWS DMS alone
Why it's wrong here
DMS cannot convert schema; SCT is needed for schema conversion from Oracle to MySQL.
Go deeper
Related to this question
About these practice questions
Courseiva writes every CV0-004 question from scratch — 977 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.