DBS-C01 Monitoring and Troubleshooting Practice Question
A company runs an Amazon Aurora MySQL database cluster with one writer and two readers. The application suddenly fails with 'Too many connections' error. The writer instance's maximum connections is set to 1000. Which configuration change would best resolve the issue while maintaining high availability?
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
✓
Enable Amazon RDS Proxy for the database cluster.
Amazon RDS Proxy acts as a connection pooler that manages database connections efficiently. By reducing connection churn and reusing connections, it prevents the 'Too many connections' error without overloading the instance. Option B is incorrect because simply increasing max_connections could lead to resource exhaustion and degradation of performance. Option C is incorrect because read replicas cannot accept write traffic; they are read-only. Option D is incorrect because manually killing idle connections is a temporary fix and not a configuration change; it does not prevent the issue from recurring.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Enable Amazon RDS Proxy for the database cluster.
Why this is correct
Correct. RDS Proxy efficiently manages database connections, reducing the number of open connections.
- ✗
Increase the max_connections parameter on the writer instance to 5000.
Why it's wrong here
Incorrect. Higher max_connections can lead to resource contention and does not address the underlying connection pattern.
- ✗
Redirect all write requests to one of the read replicas.
Why it's wrong here
Incorrect. Read replicas do not accept write operations.
- ✗
Manually kill idle connections from the database.
Why it's wrong here
Incorrect. This is a temporary fix and not a configuration change.
Visual reference
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-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 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.