DBS-C01 Deployment and Migration Practice Question
A company is migrating a 5 TB MySQL database to Amazon Aurora MySQL. The migration must have zero downtime and the source database is continuously written to. The team plans to use AWS DMS with ongoing replication. However, they notice that the target Aurora instance is not receiving all changes from the source. Which configuration change is most likely required to resolve this?
⚠ Common exam trap
The trap here is that candidates may overlook the fundamental prerequisite of binary logging for DMS ongoing replication and instead focus on network connectivity (VPC endpoints) or task configuration settings that do not address the root cause of missing change capture.
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
✓
Enable binary logging (binlog) on the source MySQL database with row-based logging.
AWS DMS requires binary logging (binlog) with row-based logging on the source MySQL database to capture ongoing changes for continuous replication. Without binlog enabled, DMS cannot read the change data stream needed to replicate transactions to the target Aurora instance, causing missed changes. This is a mandatory prerequisite for any MySQL-to-Aurora migration using DMS with ongoing replication.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Create an Amazon RDS read replica of the source database and use it as the source endpoint.
Why it's wrong here
DMS can use a read replica as source, but the issue is likely not about source endpoint type.
- ✗
Set the target table preparation mode to 'Do nothing' in the DMS task.
Why it's wrong here
This affects how target tables are handled before load, not ongoing replication capture.
- ✓
Enable binary logging (binlog) on the source MySQL database with row-based logging.
Why this is correct
DMS needs binlogs for ongoing replication; if not enabled, it cannot capture changes.
- ✗
Configure a VPC endpoint for the DMS replication instance.
Why it's wrong here
VPC endpoints are not required for DMS; DMS connects via the replication instance's network.
Visual reference
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.