AWS Certified CloudOps Engineer Associate SOA-C03 Practice Question
An ecommerce company runs a MySQL 8.0 DB instance in one AZ. During flash sales, Amazon CloudWatch shows the DatabaseConnections metric spikes close to the instance limit and FreeableMemory falls sharply. Hundreds of short-lived Lambda invocations open new database sessions. The team wants to relieve memory pressure without changing application logic and would like to use IAM database authentication. Which solution meets these requirements with the least effort?
Launch a larger DB instance class and increase the max_connections parameter in a custom parameter group.
Create an Amazon RDS Proxy for the DB instance, enable IAM authentication, and update the Lambda functions to connect to the proxy endpoint.
Deploy an Amazon ElastiCache for Memcached cluster and cache connection objects for reuse across function invocations.
Add a read replica and configure the Lambda functions to spread writes and reads using Amazon Route 53 weighted records.
Amazon RDS Proxy sits between an application and its database and maintains a pool of established connections that can be reused by short-lived clients such as Lambda functions. This dramatically reduces the total number of concurrent database sessions, which in turn lowers memory consumption on the DB instance. RDS Proxy natively supports IAM database authentication, so no credential management changes are required. Upgrading the DB instance class or increasing the max_connections parameter is costlier and only masks the symptom. Adding a read replica does not reduce the write-side connection load, and routing writes to multiple endpoints risks data inconsistency. Caching connection objects in ElastiCache does not help because each Lambda invocation would still create a new TCP session to MySQL. Therefore, creating and using an Amazon RDS Proxy is the most effective and least disruptive solution.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Amazon RDS Proxy?
Open an interactive chat with Bash
How does IAM database authentication with RDS Proxy work?
Open an interactive chat with Bash
Why doesn't increasing the max_connections parameter solve memory pressure issues?
Open an interactive chat with Bash
AWS Certified CloudOps Engineer Associate SOA-C03
Monitoring, Logging, Analysis, Remediation, and Performance Optimization
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .