DEA-C01 AWS DMS Parallel Tables Practice Question
A company is using AWS Database Migration Service (DMS) to migrate a 2 TB MySQL database to Amazon Aurora MySQL. The migration is taking longer than expected. The source database is in a different AWS region. Which change would MOST likely improve the migration speed?
⚠ Common exam trap
Candidates often confuse Multi-AZ with performance improvement, but Multi-AZ is solely for high availability. For cross-region migrations, the bottleneck is network bandwidth; increasing parallelism is the most effective way to improve throughput.
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
✓
Increase the number of parallel tables being migrated.
Increasing the number of parallel tables allows DMS to migrate multiple tables simultaneously, leveraging available bandwidth and reducing overall migration time. This is particularly effective for large databases (2 TB) where serial migration would be slow. Option B is incorrect because Multi-AZ provides high availability, not performance improvement; it adds overhead and does not reduce network latency. Option A reduces resources, making migration slower. Option D disables binary logging, which is needed for ongoing replication and can cause data loss or require a full re-sync.
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 a smaller DMS replication instance to reduce costs.
Why it's wrong here
Using a smaller DMS replication instance reduces compute and memory resources, which slows the migration. This would not improve speed.
- ✗
Use a Multi-AZ deployment for the DMS replication instance in the target region.
Why it's wrong here
Multi-AZ deployment is for high availability and failover, not for performance. It does not improve migration speed and may add overhead.
- ✓
Increase the number of parallel tables being migrated.
Why this is correct
Increasing the number of parallel tables allows DMS to migrate multiple tables at once, utilizing more of the available bandwidth and reducing total migration time, especially for a large database.
- ✗
Disable binary logging on the source MySQL database.
Why it's wrong here
Disabling binary logging on the source MySQL database prevents ongoing replication and can cause data loss or require a full re-sync if the migration needs to be resumed. It does not speed up the initial load.
Go deeper
Related to this question
About these practice questions
This DEA-C01 question is part of Courseiva's 1,711-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 →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DEA-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 DEA-C01 exam.