Explanation:
The correct answer is B. Using Amazon RDS Proxy can significantly improve the efficiency of the database connections by pooling and sharing established database connections, which can reduce the load on the Aurora PostgreSQL database. This change requires minimal modification to the application, as the Lambda function only needs to be updated to use the RDS Proxy endpoint instead of the direct database endpoint. This solution effectively addresses the issue of high CPU and memory utilization on the database due to a large number of open connections during peak times, thereby preventing timeouts.
Ultimate access to all questions.
No comments yet.
An e-commerce company's order-processing app, using Amazon API Gateway and AWS Lambda, stores data in an Aurora PostgreSQL DB. During peak sales, customer order timeouts occurred due to high DB CPU and memory usage from many open connections. What's the minimal change to prevent timeouts?
A
Set up Lambda provisioned concurrency and make the DB a global database across AWS Regions.
B
Implement Amazon RDS Proxy for the DB and update Lambda to use the proxy endpoint.
C
Add a DB read replica in another Region and direct traffic using API Gateway query parameters.
D
Switch from Aurora PostgreSQL to DynamoDB using AWS DMS and adjust Lambda to access the new DB.