SAP-C02 Continuous Improvement for Existing Solutions Practice Question
A company is using AWS Elastic Beanstalk to deploy a web application. The application's performance degrades over time due to increasing database connections. The company wants to implement a solution that automatically scales the database tier based on connection count. Which action should be taken?
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 Amazon RDS Proxy to manage database connections and enable connection pooling.
Amazon RDS Proxy manages connection pooling and can scale with application, reducing load on database. Option A is wrong because DynamoDB is a different database. Option C is wrong because scaling EC2 instances does not address database connections. Option D is wrong because modifying RDS instance type is manual and not automatic.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Migrate the database to Amazon DynamoDB with auto scaling.
Why it's wrong here
Not a direct replacement for relational database.
- ✓
Use Amazon RDS Proxy to manage database connections and enable connection pooling.
Why this is correct
RDS Proxy reduces connection overhead and scales.
- ✗
Enable Multi-AZ on the RDS instance and modify the DB instance class.
Why it's wrong here
Manual, not automatic scaling.
- ✗
Configure the Auto Scaling group to scale based on CPU utilization.
Why it's wrong here
Does not address database connection issue.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SAP-C02 question from scratch — 1,660 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 SAP-C02 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 SAP-C02 exam.