DEA-C01 Data Store Management Practice Question
A company uses an Amazon RDS for MySQL DB instance with Multi-AZ deployment. The primary DB instance fails unexpectedly. What happens to the database endpoint?
⚠ Common exam trap
A common mix-up: candidates think a new endpoint is created or that manual DNS changes are required, confusing Multi-AZ failover with a manual snapshot restore or a cross-region read replica promotion.
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
✓
The existing endpoint continues to work and automatically points to the standby DB instance.
In a Multi-AZ RDS deployment, the DNS endpoint remains unchanged during a failover. When the primary DB instance fails, Amazon RDS automatically updates the DNS record to point to the standby instance in the other Availability Zone. This ensures the application can continue using the same endpoint without any manual intervention, providing high availability.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A new endpoint is created for the standby and the application must use the new endpoint.
Why it's wrong here
The same endpoint is used; RDS handles the DNS change.
- ✓
The existing endpoint continues to work and automatically points to the standby DB instance.
Why this is correct
RDS automatically updates the DNS CNAME record to point to the standby instance.
- ✗
The database becomes unavailable until the primary is restored from a snapshot.
Why it's wrong here
Multi-AZ provides automatic failover to the standby.
- ✗
The existing endpoint is deleted and a new endpoint is provided after manual DNS update.
Why it's wrong here
Failover is automatic, no manual DNS update needed.
Visual reference
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.