Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 354 discussion

Many applications, including those built on modern serverless architectures, can have a large number of open connections to the database server and may open and close database connections at a high rate, exhausting database memory and compute resources. Amazon RDS Proxy allows applications to pool and share connections established with the database, improving database efficiency and application scalability. With RDS Proxy, failover times for Aurora and RDS databases are reduced by up to 66%. https://aws.amazon.com/rds/proxy/

A. Reduce the Lambda concurrency rate? Has nothing to do with decreasing connections timeout. B. Enable RDS Proxy on the RDS DB instance. Correct answer C. Resize the RDS DB instance class to accept more connections? More connections means worse performance. Therefore, not correct. D. Migrate the database to Amazon DynamoDB with on-demand scaling? DynamoDB is a noSQL database. Not correct.

Keys found in STEM: 1. The company notices an increase in application errors that result from database connection timeouts during times of peak traffic or unpredictable traffic. 2. The company needs a solution that reduces the application failures with the least amount of change to the code.

RDS Proxy is a fully managed, highly available, and scalable proxy for Amazon Relational Database Service (RDS) that makes it easy to connect to your RDS instances from applications running on AWS Lambda. RDS Proxy offloads the management of connections to the database, which can help to improve performance and reliability.

To reduce application failures resulting from database connection timeouts, the best solution is to enable RDS Proxy on the RDS DB instance

RDS Proxy

RDS Proxy will pool connections, no code changes need to be made

RDS proxy

B RDS Proxy https://aws.amazon.com/rds/proxy/