SAA-C03 · Question #441
A company has a web application that uses Amazon API Gateway to route HTTPS requests to AWS Lambda functions. The application uses an Amazon Aurora MySQL database for its data storage. The application
The correct answer is A. Create an Amazon RDS proxy for the database. Replace the database endpoint with the proxy. Amazon RDS Proxy helps manage and pool database connections from serverless compute like AWS Lambda, significantly reducing the stress on the database during unpredictable traffic surges. It improves scalability and resiliency by efficiently managing connections, protecting the d
Question
A company has a web application that uses Amazon API Gateway to route HTTPS requests to AWS Lambda functions. The application uses an Amazon Aurora MySQL database for its data storage. The application has experienced unpredictable surges in traffic that overwhelm the database with too many connection requests. The company wants to implement a scalable solution that is more resilient to database failures. Which solution will meet these requirements MOST cost-effectively?
Options
- ACreate an Amazon RDS proxy for the database. Replace the database endpoint with the proxy
- BMigrate the database to Amazon DynamoDB tables by using AWS Database Migration Service
- CReview the existing connections. Call MySQL queries to end any connections in the sleep state.
- DIncrease the instance class of the database with more memory. Set a larger value for the
How the community answered
(53 responses)- A81% (43)
- B2% (1)
- C6% (3)
- D11% (6)
Explanation
Amazon RDS Proxy helps manage and pool database connections from serverless compute like AWS Lambda, significantly reducing the stress on the database during unpredictable traffic surges. It improves scalability and resiliency by efficiently managing connections, protecting the database from being overwhelmed, and enabling failover handling. Option A is the most cost-effective and operationally efficient approach to handling unpredictable surges and improving resilience without requiring major application changes. Option B involves a migration to DynamoDB, which is a significant architectural change and costlier initially. Option C is manual connection cleanup, insufficient for unpredictable surges. Option D increases resources but does not solve connection storm problems efficiently and is
Community Discussion
No community discussion yet for this question.