AWS Certified Solutions Architect – Associate (SAA-C03) — Question 626

A company runs applications on AWS that connect to the company's Amazon RDS database. The applications scale on weekends and at peak times of the year. The company wants to scale the database more effectively for its applications that connect to the database.

Which solution will meet these requirements with the LEAST operational overhead?

Answer options

• A. Use Amazon DynamoDB with connection pooling with a target group configuration for the database. Change the applications to use the DynamoDB endpoint.
• B. Use Amazon RDS Proxy with a target group for the database. Change the applications to use the RDS Proxy endpoint.
• C. Use a custom proxy that runs on Amazon EC2 as an intermediary to the database. Change the applications to use the custom proxy endpoint.
• D. Use an AWS Lambda function to provide connection pooling with a target group configuration for the database. Change the applications to use the Lambda function.

Correct answer: B

Explanation

Amazon RDS Proxy is a fully managed database proxy that automatically pools and shares database connections, which reduces operational overhead and helps applications scale efficiently. Implementing a custom proxy on Amazon EC2 or using AWS Lambda for connection pooling requires significant manual configuration and maintenance, increasing operational overhead. Amazon DynamoDB is a NoSQL database service and cannot be used as a connection proxy for an Amazon RDS database.