SAA-C03 Question 502
Single answerA company is running a multi-tier application on AWS. The application uses an Amazon RDS PostgreSQL database as the backend. During peak traffic, the number of database connections exceeds the configured limit, causing application errors. The company wants to implement a solution to manage database connections effectively and improve application performance without modifying the application code. What is the BEST solution to address this issue?
- A
Use Amazon RDS Proxy to pool and manage database connections.
- B
Increase the maximum number of connections in the RDS PostgreSQL database.
- C
Use an Auto Scaling group to dynamically scale the RDS database instance during peak traffic.
- D
Deploy an Amazon ElastiCache cluster in front of the database to cache frequently accessed queries.
Show answer and explanation
Correct answer: A
Explanation
The best solution for managing database connections without modifying application code is to use Amazon RDS Proxy. It pools database connections, handles connection limits efficiently, and improves application scalability during high traffic. Other options either address different problems or are not directly applicable to the scenario.
- A. Correct.
This is the correct answer. Amazon RDS Proxy acts as a database connection pooler, allowing you to manage and optimize database connections effectively. It reduces the overhead of opening and closing connections during high traffic and does not require changes to the application code.
- B. Incorrect.
Although increasing the maximum number of connections might temporarily resolve the issue, it does not address the root cause. Managing connections more efficiently with a connection pooler like Amazon RDS Proxy is a better solution.
- C. Incorrect.
Auto Scaling is not applicable to Amazon RDS instances directly. While you can scale the instance size, this would not resolve the issue with connection limits during peak traffic.
- D. Incorrect.
ElastiCache can improve performance by caching queries, but it does not manage database connections or resolve issues related to exceeding connection limits.