A company runs a customer portal on an Amazon Aurora PostgreSQL cluster. The application currently connects directly to the writer instance endpoint and keeps long-lived connections open. During a maintenance failover, writes fail until clients are restarted. The team wants the application to reconnect to the correct Aurora endpoint automatically and reduce user-visible write interruptions.
Which change is most likely to achieve this?
Answer choices
Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.
Use the Aurora cluster endpoint for write traffic, use the reader endpoint for read-only traffic, and implement connection retry or reconnect logic on failover.
The cluster endpoint always targets the current writer, and failover-aware reconnect logic helps the application recover from dropped connections after promotion.
Keep using the original writer instance endpoint so the database host name never changes during failover.
An instance endpoint can still point to the old writer after failover, causing write failures until the instance becomes writer again.
Convert the Aurora cluster to Single-AZ so there is only one database node to connect to.
Single-AZ reduces availability and does not improve failover behavior or reduce interruption during maintenance events.
Place Route 53 in front of the database and manually update DNS records whenever failover occurs.
Manual DNS updates increase recovery time and are unnecessary when Aurora endpoints already handle writer promotion.
Common exam trap
Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.
Technical deep dive
This question should be treated as a scenario, not a definition check. Identify the problem, the constraint and the best action. Then compare each option against those facts.
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise SAA-C03 questions linked to SAA-C03 VPC.
Practise SAA-C03 questions linked to SAA-C03 S3 lifecycle policy questions.
Practise SAA-C03 questions linked to SAA-C03 RDS Multi-AZ questions.
Practise SAA-C03 questions linked to SAA-C03 IAM policy.
Practise SAA-C03 questions linked to SAA-C03 Route 53 failover questions.
Practise SAA-C03 questions linked to SAA-C03 CloudFront.
Practise SAA-C03 questions linked to SAA-C03 NAT gateway questions.
Practise SAA-C03 questions linked to SAA-C03 VPC endpoint questions.
Practise SAA-C03 questions linked to SAA-C03 Auto Scaling.
Practise SAA-C03 questions linked to SAA-C03 disaster recovery questions.
Practise SAA-C03 questions linked to SAA-C03 high availability questions.
Practise SAA-C03 questions linked to SAA-C03 cost optimization questions.
Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
FAQ
Read the scenario before looking for a memorised answer.
The correct answer is: Use the Aurora cluster endpoint for write traffic, use the reader endpoint for read-only traffic, and implement connection retry or reconnect logic on failover. — Aurora failover promotes a new writer and updates the cluster endpoint to point to that writer, but applications with long-lived connections still need to reconnect or retry after the old connection drops. Using the cluster endpoint for write traffic avoids pinning the app to a specific instance, and using the reader endpoint for read-only traffic keeps read scaling separate. Failover-aware reconnect logic is what reduces user-visible write interruptions after a maintenance event. Why others are wrong: Pinning the application to the original writer instance endpoint can leave the app connected to the old instance after failover, causing write errors. Switching to Single-AZ removes the resilience benefit of Aurora failover. Putting Route 53 in front of the database is unnecessary and would add operational overhead without solving stale database connections.
Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.
Sign in to join the discussion.