SAA-C03 Question 300
Single answerA company is running a highly available application on Amazon RDS for PostgreSQL. The application has recently experienced an increase in traffic, resulting in intermittent connection errors due to the high number of database connections. The company wants to implement a solution to better handle the connection load and improve database performance without making changes to the application code. Which solution should the company implement?
- A
Enable Amazon RDS Proxy for the PostgreSQL database.
- B
Scale the RDS instance to a larger instance type with more CPU and memory.
- C
Use Amazon ElastiCache to cache frequently accessed database queries.
- D
Enable Multi-AZ deployments for the RDS instance.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS Proxy is designed to manage and pool database connections. By enabling RDS Proxy, the company can reduce the load on the database from a high number of connections, improve application scalability, and avoid the need for application code changes. This makes it the most effective and efficient solution to the given problem.
- A. Correct.
Enabling Amazon RDS Proxy is the correct solution. RDS Proxy manages and pools database connections, helping to handle a large number of connections more efficiently and reducing the overhead on the database.
- B. Incorrect.
Scaling the RDS instance to a larger instance type might temporarily alleviate the issue but does not address the root cause of connection management. It also incurs higher costs and may not fully solve the problem.
- C. Incorrect.
Using Amazon ElastiCache can improve query performance by caching results, but it does not address connection handling or reduce the number of connections to the database.
- D. Incorrect.
Enabling Multi-AZ deployments improves database availability and durability but does not help with connection management or performance under high connection loads.