AWS Certified Solutions Architect – Professional (SAP-C02) — Question 418

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 to Amazon Aurora with an Aurora Replica enhances both performance scalability and availability due to Aurora's fast replication and automated failover capabilities. Using Amazon RDS Proxy is the optimal solution for Lambda-based applications, as it pools and shares database connections to prevent the database from being overwhelmed by highly concurrent Lambda executions. Other options either do not address connection pooling effectively at scale or use incorrect routing mechanisms like Route 53 for database read replicas.