Courseiva
Deployment and MigrationeasyMultiple ChoiceObjective-mapped

DBS-C01 Deployment and Migration Practice Question

A company is migrating a 10 GB MySQL database to Amazon RDS for MySQL. They have a 1 Gbps connection to AWS. The migration must be completed in the least amount of time with minimal manual effort. Which tool should be used?

⚠ Common exam trap

A common mix-up: candidates choose mysqldump (Option C) because it is familiar and free, but they overlook the requirement for minimal manual effort and the need for continuous replication, which DMS provides automatically.

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 Database Migration Service (DMS).

AWS Database Migration Service (DMS) is the correct choice because it can perform a live, continuous migration of a 10 GB MySQL database to Amazon RDS for MySQL with minimal downtime and manual effort. DMS handles schema conversion (if needed), data replication, and ongoing changes via Change Data Capture (CDC), allowing the migration to complete in the least amount of time while automatically managing the full load and sync process over the 1 Gbps connection.

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 Schema Conversion Tool (SCT).

    Why it's wrong here

    SCT converts schema, not data.

  • AWS Snowball Edge.

    Why it's wrong here

    A 10 GB database can be transferred over a 1 Gbps connection in minutes, making physical shipment of a Snowball Edge device far slower than direct network transfer. Snowball Edge is designed for offline bulk data migration when bandwidth is limited or unavailable, not for small datasets over fast links. Its use would introduce unnecessary shipping and staging delays, contradicting the requirement for minimal time and manual effort.

  • mysqldump and mysql command-line tools.

    Why it's wrong here

    While functional, this requires manual steps and the database must be offline during export.

  • AWS Database Migration Service (DMS).

    Why this is correct

    DMS automates the migration process and can complete quickly over high bandwidth.

About these practice questions

One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.