DEA-C01 Data Ingestion and Transformation Practice Question
A company uses AWS DMS to replicate data from an Amazon RDS for MySQL database to Amazon S3. Which TWO configurations are required to enable continuous change data capture (CDC) from MySQL?
⚠ Common exam trap
DEA-C01 often tests the specific prerequisites for MySQL CDC with DMS. Candidates might think that Multi-AZ or S3 versioning is required, but the key requirements are binlog and replication privileges. It's also common to confuse REPLICATION CLIENT with other privileges like SELECT.
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
✓
Grant REPLICATION CLIENT and REPLICATION SLAVE privileges to the DMS user
Option B is correct because AWS DMS requires the MySQL endpoint user to have REPLICATION CLIENT (to read binlog metadata/status) and REPLICATION SLAVE (to read the binary log events) privileges so it can capture ongoing changes for CDC. Option C is correct because continuous change data capture depends on the MySQL source having binary logging enabled (log_bin=ON) with a suitable binlog_format (e.g., ROW) so DMS can read committed changes from the binlog. Option A is not required, since DMS can replicate to an S3 bucket in a different Region than the source database. Option D is not required, as S3 bucket versioning is unrelated to DMS CDC and is not needed for change capture. Option E is not required, because Multi-AZ is a high-availability deployment choice for the source and does not enable or affect DMS change data capture.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Ensure the S3 bucket is in the same AWS Region as the source database
Why it's wrong here
DMS reads from the MySQL source and writes to S3 across Regions without issue, so co-location is not a CDC prerequisite. It is tempting because latency and data-transfer costs favour proximity, and same-Region placement would be the correct configuration when minimising replication lag or egress charges, not enabling CDC.
- ✓
Grant REPLICATION CLIENT and REPLICATION SLAVE privileges to the DMS user
Why this is correct
DMS requires REPLICATION CLIENT to read binlog metadata and REPLICATION SLAVE to stream binlog events as a replica. Granting both to the DMS user satisfies the stem's continuous CDC requirement, since MySQL denies replication access without these specific global privileges.
- ✓
Enable binary logging (binlog) on the MySQL source database
Why this is correct
MySQL records row-level changes in the binary log, which AWS DMS reads to capture ongoing inserts, updates, and deletes. Enabling binlog on the RDS source satisfies the stem's continuous CDC requirement, since without it DMS can perform only a one-time full load.
- ✗
Enable versioning on the target S3 bucket
Why it's wrong here
S3 bucket versioning protects against overwrites and deletions; it plays no part in MySQL binary log capture. It is tempting because versioning is often enabled alongside replication for durability, and it would be the correct configuration when the requirement is recovering overwritten target objects, not enabling CDC.
- ✗
Configure the MySQL source to be Multi-AZ
Why it's wrong here
Multi-AZ provides synchronous standby failover for availability; it does not generate or expose the binary log records DMS reads. It is tempting because Multi-AZ is a common RDS resilience setting, and it would be the correct configuration when the requirement is high availability of the source database, not change data capture.
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
This DEA-C01 question is part of Courseiva's 1,321-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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Amazon Web Services exam blueprint
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.