DEA-C01 Data Store Management Practice Question
A company has an Amazon RDS for MySQL DB instance with read replicas. The primary DB instance fails. What is the correct procedure to promote a read replica to become the new primary?
⚠ Common exam trap
Test-takers frequently confuse read replicas with Multi-AZ standby instances, assuming automatic failover applies to both, but RDS read replicas require manual promotion and do not provide automatic failover.
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
✓
Manually promote the read replica to a standalone DB instance.
When an Amazon RDS for MySQL primary DB instance fails, read replicas do not automatically become the new primary. The correct procedure is to manually promote the read replica using the AWS Management Console, CLI, or API, which converts it into a standalone DB instance. After promotion, you must update your application endpoints to point to the new primary, as RDS does not handle this automatically.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Modify the read replica to be a Multi-AZ deployment and failover will occur.
Why it's wrong here
Modifying to Multi-AZ does not promote the replica; it creates a standby in another AZ.
- ✗
RDS automatically fails over to the read replica within 5 minutes.
Why it's wrong here
RDS does not automatically fail over to a read replica; you must manually promote.
- ✓
Manually promote the read replica to a standalone DB instance.
Why this is correct
This is the correct procedure to make the read replica the new primary.
- ✗
Delete the primary and the read replica will automatically become the primary.
Why it's wrong here
Deleting the primary does not promote the replica; the replica remains a replica.
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.