DBS-C01 Management and Operations Practice Question
A company is migrating a 5 TB MySQL database to Amazon Aurora MySQL. The migration must have minimal downtime and support ongoing replication. The source database is in a corporate data center with a 500 Mbps internet connection. Which THREE steps should the database specialist take?
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 Schema Conversion Tool (AWS SCT) to convert the schema.
Options B, D, and E are correct. Option B: The AWS Schema Conversion Tool (AWS SCT) converts the source MySQL schema to be compatible with Aurora MySQL, which is often necessary due to differences in storage engines or features. Option D: AWS Database Migration Service (AWS DMS) with change data capture (CDC) enables ongoing replication and minimizes downtime by continuously syncing changes from the source database to the target Aurora database. Option E: An AWS Snowball Edge device is used for the initial data load, which transfers the 5 TB database over a fast local connection to AWS, reducing the time required compared to the 500 Mbps internet connection. Option A is incorrect because using a VPN and mysqldump would result in significant downtime and slower data transfer; it does not support ongoing replication. Option C is incorrect because creating an Aurora read replica is not a migration method; read replicas are used for read scaling within a managed Aurora environment, not for migrating data from an external source.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Establish a VPN connection to AWS and use mysqldump.
Why it's wrong here
mysqldump over slow internet would take too long.
- ✓
Use AWS Schema Conversion Tool (AWS SCT) to convert the schema.
Why this is correct
SCT helps with schema conversion if needed.
- ✗
Create an Aurora read replica from the source database.
Why it's wrong here
Read replicas are not used for migration.
- ✓
Set up AWS Database Migration Service (AWS DMS) with change data capture (CDC).
Why this is correct
DMS with CDC enables minimal downtime migration.
- ✓
Use an AWS Snowball Edge device to transfer the initial data load.
Why this is correct
Snowball Edge accelerates initial data transfer for large datasets.
Quick reference
AWS S3 Storage Class Comparison
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
Go deeper
Related to this question
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 →
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.