DEA-C01 Data Store Management Practice Question
A data engineer is setting up an Amazon RDS for MySQL database. The database must be highly available and automatically failover in case of an AZ outage. Which TWO configurations should the engineer enable? (Choose TWO.)
⚠ Common exam trap
A common mix-up: candidates confuse read replicas or automated backups with high availability failover, but only Multi-AZ deployment provides automatic, synchronous failover within the same region.
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
✓
Multi-AZ deployment
Multi-AZ deployment (Option A) automatically provisions and maintains a synchronous standby replica in a different Availability Zone (AZ). In the event of an AZ outage, Amazon RDS automatically fails over to the standby, ensuring high availability with minimal downtime. This is the core mechanism for automatic failover in RDS for MySQL.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Multi-AZ deployment
Why this is correct
Multi-AZ creates a standby instance in a different Availability Zone for automatic failover.
- ✓
A DB subnet group with subnets in at least two Availability Zones
Why this is correct
A Multi-AZ deployment requires subnets in at least two AZs to place the primary and standby.
- ✗
Enhanced Monitoring
Why it's wrong here
Enhanced Monitoring provides metrics, not high availability.
- ✗
Automated backups with a retention period of 30 days
Why it's wrong here
Backups are for recovery, not for failover.
- ✗
Read replicas in a different Region
Why it's wrong here
Read replicas do not provide automatic failover; they are for read scaling.
Go deeper
Related to this question
About these practice questions
One of 1,711 original DEA-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 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.