SAA-C03 Design Resilient Architectures Practice Question
A company uses an Amazon Aurora DB cluster in a Multi-AZ configuration. During a planned failover of the writer instance, the database endpoints in the application are updated incorrectly. After failover, reads work but writes fail with connection errors and timeouts for several minutes. The team currently uses the instance endpoint for the writer. What should they change to improve write resilience during failovers?
⚠ Common exam trap
Many candidates confuse the instance endpoint (which is static and tied to a specific instance) with the cluster endpoint (which is dynamic and always points to the current writer), assuming any endpoint will automatically follow 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
✓
Use the Aurora cluster writer endpoint for all write operations.
The Aurora cluster writer endpoint always points to the current primary (writer) instance, even after a failover. By using this endpoint instead of a static instance endpoint, the application automatically resolves to the new writer without manual updates, eliminating connection errors and timeouts during failover transitions.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Continue using the instance endpoint, but increase application retry count so the writer changes are handled more quickly.
Why it's wrong here
Retries can reduce perceived impact, but the instance endpoint can become non-writer after failover. If the application continues targeting an instance endpoint that no longer accepts writes, retries will continue to fail until the code or endpoint selection is corrected.
- ✓
Use the Aurora cluster writer endpoint for all write operations.
Why this is correct
Aurora provides a writer endpoint designed specifically for write traffic. During failover, Aurora updates where the writer endpoint points, so the same DNS name continues to resolve to the current writer instance without requiring manual endpoint changes in the application.
- ✗
Use a read replica endpoint for writes because it is typically stable across failovers.
Why it's wrong here
Aurora reader endpoints are designed to balance read-only traffic across replica instances, and those replicas do not accept write operations. Even if a reader endpoint remains stable during a failover, it will reject INSERT/UPDATE/DELETE statements because only the current writer instance can process writes. Moreover, reader endpoints may be repointed or replaced during promotion, so they are not a reliable target for writes.
- ✗
Disable Multi-AZ failover so the writer instance never changes and writes remain consistent.
Why it's wrong here
Aurora does not allow disabling Multi-AZ failover without removing the replicas that provide it; doing so sacrifices automatic recovery and creates a single point of failure. The writer instance can still change due to manual failover, patch maintenance, or an unplanned instance failure, so disabling failover does not guarantee a stable writer. Write consistency is maintained by Aurora's storage engine and quorum, not by disabling failover, so this approach incorrectly trades availability for a false sense of endpoint stability.
Visual reference
Go deeper
Related to this question
About these practice questions
One of 935 original SAA-C03 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 SAA-C03 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 SAA-C03 exam.