SAA-C03 Question 504
Single answerA company has a web application hosted on Amazon EC2 instances behind an Application Load Balancer (ALB). The application interacts with an Amazon RDS database. The development team has noticed intermittent latency issues when the application scales up during peak traffic. Upon investigation, they find that the database is experiencing too many connection requests from the EC2 instances. What is the MOST effective solution to address this issue?
- A
Use Amazon RDS Proxy to manage the database connections.
- B
Upgrade the Amazon RDS instance to a larger instance type with more CPU and memory.
- C
Enable Multi-AZ deployment for the Amazon RDS database.
- D
Increase the maximum number of connections allowed by the Amazon RDS database.
Show answer and explanation
Correct answer: A
Explanation
The problem occurs because the application is overwhelming the database with too many connection requests during scaling events. Amazon RDS Proxy is specifically designed to handle such situations by pooling and reusing database connections, reducing the load on the database and improving application performance. This makes it the most effective and scalable solution for this scenario.
- A. Correct.
Using Amazon RDS Proxy allows the application to pool and share database connections, reducing the overhead on the database and solving the issue of too many connection requests. This is the most effective solution to address connection latency during scaling.
- B. Incorrect.
Upgrading the RDS instance may temporarily alleviate the latency issues, but it does not address the root cause of too many connection requests. This is not the most efficient solution.
- C. Incorrect.
Enabling Multi-AZ deployment improves availability and fault tolerance but does not solve the issue of excessive database connections causing latency.
- D. Incorrect.
Increasing the maximum number of connections allowed by the database might reduce connection errors temporarily but can lead to resource exhaustion on the database, worsening the problem during peak traffic.