AWS Certified Solutions Architect – Professional — Question 629

A company runs a software-as-a-service (SaaS) application on AWS. The application consists of AWS Lambda functions and an Amazon RDS for MySQL Multi-
AZ database. During market events, the application has a much higher workload than normal. Users notice slow response times during the peak periods because of many database connections. The company needs to improve the scalable performance and availability of the database.
Which solution meets these requirements?

Answer options

• A. Create an Amazon CloudWatch alarm action that triggers a Lambda function to add an Amazon RDS for MySQL read replica when resource utilization hits a threshold.
• B. Migrate the database to Amazon Aurora, and add a read replica. Add a database connection pool outside of the Lambda handler function.
• C. Migrate the database to Amazon Aurora, and add a read replica. Use Amazon Route 53 weighted records.
• D. Migrate the database to Amazon Aurora, and add an Aurora Replica. Configure Amazon RDS Proxy to manage database connection pools.

Correct answer: D

Explanation

Migrating the database to Amazon Aurora and utilizing Aurora Replicas significantly enhances availability and scalability compared to standard RDS. Furthermore, using Amazon RDS Proxy is the best practice for managing connection limits when integrating with AWS Lambda, as it pools and shares database connections efficiently to prevent exhaustion during peak traffic periods. Other options either do not scale connections automatically or fail to use the fully managed proxy service designed for serverless architectures.