SAA-C03 · Question #401
A company has a transaction-processing application that is backed by an Amazon RDS MySQL database. When the load on the application increases, a large number of database connections are opened and clo
The correct answer is C. Use Amazon RDS Proxy to pool and share database connections.. Amazon RDS Proxy is a fully managed database proxy for RDS that makes applications more scalable, more resilient to database failures, and more secure. RDS Proxy pools and shares database connections, allowing applications to open and close connections as needed without overwhelm
Question
A company has a transaction-processing application that is backed by an Amazon RDS MySQL database. When the load on the application increases, a large number of database connections are opened and closed frequently, which causes latency for the database transactions. A solutions architect determines that the root cause of the latency is poor connection handling by the application. The solutions architect cannot modify the application code. The solutions architect needs to manage database connections to improve the database performance during periods of high load. Which solution will meet these requirements?
Options
- AUpgrade the database instance to a larger instance type to handle a large number of database
- BConfigure Amazon RDS storage autoscaling to dynamically increase the provisioned IOPS.
- CUse Amazon RDS Proxy to pool and share database connections.
- DConvert the database instance to a Multi-AZ deployment.
How the community answered
(23 responses)- A4% (1)
- B9% (2)
- C83% (19)
- D4% (1)
Explanation
Amazon RDS Proxy is a fully managed database proxy for RDS that makes applications more scalable, more resilient to database failures, and more secure. RDS Proxy pools and shares database connections, allowing applications to open and close connections as needed without overwhelming the database. This is the recommended solution when the application cannot be modified to use connection pooling itself.
Community Discussion
No community discussion yet for this question.