SAA-C03 Question 204
Single answerA company is running a multi-tenant application using Amazon RDS for its database. The application experiences unpredictable spikes in traffic, leading to frequent connection timeouts due to the high number of database connections. The development team wants to improve database connection management without modifying the application code. Which solution is the most appropriate for this scenario?
- A
Configure Amazon RDS Proxy to pool and share database connections.
- B
Enable Amazon RDS read replicas to offload read traffic and reduce database connections.
- C
Increase the instance size of the Amazon RDS database to handle more connections.
- D
Enable Multi-AZ deployments on the Amazon RDS instance to improve connection handling.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS Proxy is the best solution for managing unpredictable spikes in database connections because it pools and shares connections efficiently, reducing the risk of connection exhaustion and improving database performance. It also works seamlessly without requiring changes to the application code. Other options either do not address the core issue of connection pooling or are not cost-effective for this use case.
- A. Correct.
Correct. Amazon RDS Proxy is specifically designed to pool and share database connections, allowing the application to handle high traffic spikes efficiently without overloading the database or requiring changes to the application code.
- B. Incorrect.
Incorrect. While read replicas can reduce the load on the primary database by offloading read traffic, they do not address the problem of connection management or connection pooling.
- C. Incorrect.
Incorrect. Increasing the instance size may temporarily handle more connections, but it does not solve the underlying issue of connection pooling or management. This is not a cost-effective or scalable solution for unpredictable traffic spikes.
- D. Incorrect.
Incorrect. Multi-AZ deployments improve database availability and fault tolerance but do not impact connection pooling or management, which is the primary issue here.