DBS-C01 Cluster endpoint Practice Question
A company has an Amazon Aurora MySQL DB cluster with a single writer and two readers. The writer instance fails, and the failover mechanism promotes one of the readers to writer. The application, which uses a custom connection pool, continues to experience errors for several minutes. What should the database administrator do to minimize downtime during future failovers?
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
✓
Modify the application to use the cluster endpoint instead of the instance endpoint.
The cluster endpoint always points to the current writer, so after a failover it automatically routes to the new writer without application changes. Option A is wrong because increasing the connection pool size does not help the application detect the new writer; it could even cause more failed connections. Option C is wrong because the reader endpoint only routes to read replicas, not the writer, so write traffic would fail. Option D is wrong because Aurora already provides Multi-AZ replication; there is no separate 'enable Multi-AZ' setting.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase the connection pool size to handle more connections.
Why it's wrong here
Increasing the connection pool size does not help the application detect the new writer after failover. It could lead to more failed connections and does not address the routing issue.
- ✓
Modify the application to use the cluster endpoint instead of the instance endpoint.
Why this is correct
The cluster endpoint automatically points to the current writer instance. After a failover, DNS is updated to point to the new writer, so using this endpoint minimizes downtime.
- ✗
Configure the application to use the reader endpoint for all traffic.
Why it's wrong here
The reader endpoint routes to read replicas only. Using it for all traffic would cause write operations to fail, especially after failover when the old reader becomes the writer.
- ✗
Enable Multi-AZ on the Aurora cluster.
Why it's wrong here
Aurora is inherently Multi-AZ; the cluster already has instances in multiple Availability Zones. No additional configuration is needed, and this does not address the connection routing issue.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-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 DBS-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 DBS-C01 exam.