SAA-C03 Question 503
Single answerAn e-commerce company is running an application using an Amazon RDS MySQL database. During peak traffic periods, the database experiences a high number of connection requests, causing performance degradation. The company wants to improve database scalability and connection handling to ensure a smooth user experience during these periods. Which solution should you recommend?
- A
Enable Amazon RDS Proxy to pool and share database connections.
- B
Increase the database instance size to handle more connections.
- C
Deploy Amazon ElastiCache to cache frequent queries and reduce the load on the database.
- D
Enable Multi-AZ deployment to distribute database connections across multiple instances.
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS Proxy is the most suitable solution for this scenario as it pools and manages database connections, which reduces the overhead on the database and improves efficiency during peak traffic. Other options, like increasing the instance size or enabling Multi-AZ, address different issues but do not solve the core challenge of managing high connection loads.
- A. Correct.
Correct: Amazon RDS Proxy is specifically designed to pool and share database connections, improving database scalability and performance under high connection loads.
- B. Incorrect.
Incorrect: Increasing the database instance size might temporarily relieve the issue, but it does not address the core problem of managing a high number of connections efficiently.
- C. Incorrect.
Incorrect: While Amazon ElastiCache can reduce database read load by caching query results, it does not address the issue of handling a large number of concurrent connections to the database.
- D. Incorrect.
Incorrect: Multi-AZ deployment enhances database availability and fault tolerance but does not provide connection pooling or load management capabilities for handling high traffic.