SAA-C03 Question 501
Single answerA company is using an Amazon RDS PostgreSQL database for its production workload. They are experiencing high connection rates during peak hours, which is causing performance degradation. As a Solutions Architect, you have been tasked with optimizing database connections to handle the load efficiently. Which solution would best address this issue?
- A
Enable Amazon RDS Proxy to pool and share database connections.
- B
Increase the instance size of the Amazon RDS database to handle more connections.
- C
Implement Amazon ElastiCache to cache frequently accessed data and reduce database load.
- D
Use AWS Direct Connect to establish a dedicated network connection to the database.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS Proxy is a fully managed service that pools and reuses database connections, making it highly efficient for applications with unpredictable and high connection rates. By using RDS Proxy, performance can be improved without requiring significant changes to the database or application, while also enhancing security and reducing database overhead.
- A. Correct.
Correct: Amazon RDS Proxy is specifically designed to pool and share database connections, reducing the overhead of creating and managing new connections. This solution is ideal for handling high connection rates efficiently.
- B. Incorrect.
Incorrect: Increasing the instance size may temporarily help handle more connections but does not address the root issue of connection management. It is also a more expensive solution.
- C. Incorrect.
Incorrect: While Amazon ElastiCache can reduce database load by caching frequently accessed data, it does not address the problem of managing database connections directly.
- D. Incorrect.
Incorrect: AWS Direct Connect improves network connectivity but does not help with database connection pooling or performance issues related to high connection rates.