DBS-C01 Deployment and Migration Practice Question
Which TWO of the following are valid methods to migrate an on-premises MySQL database to Amazon RDS for MySQL? (Select TWO.)
⚠ Common exam trap
It's easy for candidates to confuse database-specific tools (pg_dump for PostgreSQL, Oracle Data Pump for Oracle, SSIS for SQL Server) with MySQL-compatible tools, leading them to select options that are technically incorrect for migrating a MySQL database to Amazon RDS for MySQL.
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 to migrate from on-premises MySQL to RDS.
AWS DMS (Database Migration Service) is a fully managed service designed to migrate databases to AWS with minimal downtime. It supports homogeneous migrations like MySQL to Amazon RDS for MySQL, handling schema conversion, data replication, and ongoing changes via change data capture (CDC). This makes option B a valid and recommended method for migrating an on-premises MySQL database to RDS.
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 pg_dump to export the data and import into RDS.
Why it's wrong here
pg_dump is for PostgreSQL.
- ✓
Use AWS DMS to migrate from on-premises MySQL to RDS.
Why this is correct
DMS supports MySQL as source.
- ✗
Use SQL Server Integration Services (SSIS) to migrate the data.
Why it's wrong here
SSIS is for SQL Server.
- ✗
Use Oracle Data Pump to export the data and import into RDS.
Why it's wrong here
Data Pump is for Oracle databases.
- ✓
Use mysqldump to export the database and import it into RDS.
Why this is correct
mysqldump is a standard MySQL export tool.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 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 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.