SAA-C03 Question 299
Single answerAn e-commerce company is using an Amazon RDS MySQL database to handle customer transactions. During peak shopping hours, the application is experiencing high latency due to a large number of database connections. The company wants to optimize database performance and connection management without modifying the application code. Which solution should you recommend?
- A
Configure an Amazon RDS Proxy to manage database connections efficiently.
- B
Enable Multi-AZ for the RDS instance to improve read performance.
- C
Increase the size of the RDS instance to handle more connections.
- D
Set up an Amazon ElastiCache cluster in front of the database to cache frequently accessed data.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS Proxy is the best solution for managing high database connection loads in this scenario. It pools database connections and reuses them efficiently, reducing connection overhead and improving performance without requiring application code changes. Other options, such as enabling Multi-AZ or increasing instance size, do not directly address the problem of connection management.
- A. Correct.
Correct. Amazon RDS Proxy is designed to manage database connections efficiently by pooling and reusing connections, which reduces overhead and improves performance without requiring changes to the application.
- B. Incorrect.
Incorrect. Multi-AZ improves database availability and failover capabilities but does not directly address connection management or reduce latency caused by too many connections.
- C. Incorrect.
Incorrect. Increasing the instance size may temporarily address the issue by providing more resources, but it does not solve the underlying problem of inefficient connection management.
- D. Incorrect.
Incorrect. While ElastiCache can improve performance by caching frequently accessed data, it does not solve the issue of connection management or reduce the number of connections to the database.