Courseiva
DeploymenthardMultiple ChoiceObjective-mapped

CV0-004 Deployment Practice Question

An organization is migrating a 50 TB on-premises Oracle database to Amazon RDS for MySQL with minimal downtime. They plan to use AWS DMS with ongoing replication. Which additional step is necessary to reduce downtime during the final cutover?

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

Enable change data capture (CDC) on the source database

To minimize downtime, after the full load, CDC replication keeps the target in sync. During final cutover, stopping application writes and applying remaining CDC changes completes the migration with very little downtime.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Use AWS Schema Conversion Tool (AWS SCT) to convert the schema

    Why it's wrong here

    Schema conversion is needed for heterogeneous migrations but does not reduce cutover downtime.

  • Enable change data capture (CDC) on the source database

    Why this is correct

    Correct. CDC allows DMS to capture ongoing changes, enabling near-zero downtime during cutover.

  • Increase the allocated storage on the target RDS instance

    Why it's wrong here

    Storage size does not affect downtime during final cutover.

  • Use AWS Snowball to transfer the initial data load

    Why it's wrong here

    Snowball is for offline data transfer, not suitable for minimizing downtime in this context.

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 →

How Courseiva writes practice questions · Editorial policy

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.