DEA-C01 Data Ingestion and Transformation Practice Question
A company uses AWS DMS to continuously replicate data from an on-premises SQL Server to Amazon Aurora MySQL. The replication lag is increasing. Which THREE actions can reduce the lag? (Choose three.)
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 parallel apply on the target endpoint.
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 parallel apply on the target endpoint.
Why this is correct
Parallel apply speeds up writes on the target.
- ✓
Filter out unnecessary tables from replication.
Why this is correct
Reducing data volume decreases lag.
- ✗
Enable DMS validation.
Why it's wrong here
Validation adds overhead, increasing lag.
- ✗
Enable Multi-AZ for the DMS replication instance.
Why it's wrong here
Multi-AZ provides high availability, not performance improvement.
- ✓
Increase the DMS replication instance size.
Why this is correct
Larger instance provides more compute and memory for replication.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DEA-C01 question from scratch — 1,711 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 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.