Courseiva
Deployment and MigrationmediumMultiple ChoiceObjective-mapped

DBS-C01 Deployment and Migration Practice Question

A company is migrating a 2 TB MySQL database to Amazon Aurora MySQL. They need to minimize downtime and ensure data consistency. Which approach should be used?

⚠ Common exam trap

Many candidates assume native MySQL replication (Option C) can be used directly with Aurora, but Aurora MySQL does not support standard MySQL replication as a replica; DMS is the AWS-native service designed for this purpose.

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

Use AWS DMS with ongoing replication (CDC).

AWS DMS with ongoing replication (CDC) is the correct approach because it allows you to perform an initial full load of the 2 TB database while continuously capturing and applying changes from the source MySQL database. This minimizes downtime by keeping the target Aurora MySQL cluster nearly synchronized, and you only need to stop writes briefly during the final cutover to ensure data consistency.

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 DMS with ongoing replication (CDC).

    Why this is correct

    DMS with CDC minimizes downtime by replicating changes.

  • Use mysqldump to export and import into Aurora.

    Why it's wrong here

    This requires downtime and is not suitable for minimizing downtime.

  • Establish AWS Direct Connect and use MySQL replication.

    Why it's wrong here

    Direct Connect is connectivity, not a migration service.

  • Use AWS SCT to convert schema and data.

    Why it's wrong here

    SCT does not handle data migration.

About these practice questions

This DBS-C01 question is part of Courseiva's 1,663-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 →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DBS-C01 practice question is part of Courseiva's free Amazon Web Services 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 DBS-C01 exam.