AWS Certified CloudOps Engineer Associate SOA-C03 Practice Question
A company runs a production MySQL 8.0 database on Amazon RDS. Performance Insights is already enabled with the default 7-day retention. Operations wants to receive an automated notification whenever the database load (average active sessions) stays above 8 for at least 5 consecutive minutes. The solution must use only managed AWS features and require the least administration. Which action will meet these requirements?
Enable Enhanced Monitoring and configure a CloudWatch alarm that notifies SNS when CPUUtilization exceeds 80 percent for 5 minutes.
Create a CloudWatch alarm on the Performance Insights metric DBLoad with a 1-minute period, threshold of 8, and 5 evaluation periods, and configure the alarm to publish to an Amazon SNS topic.
Set up an RDS event subscription for a high-load Performance Insights event and have Amazon RDS send the event to an SNS topic.
Schedule an EventBridge rule that triggers an AWS Lambda function every minute to query the Performance Insights API, and have the function publish to SNS if DBLoad is greater than 8.
Performance Insights automatically publishes the DBLoad metric to Amazon CloudWatch for each DB instance. Creating a standard CloudWatch alarm on that metric with a 1-minute period and a threshold of 8 that must be breached for 5 consecutive datapoints generates an alarm state after five minutes of sustained load. Associating the alarm with an Amazon SNS topic delivers the required notification, and no custom code or non-AWS service is needed.
RDS event subscriptions do not emit a high-load event, so that option cannot alert on DBLoad. An alarm on CPUUtilization might miss database-specific waits and does not directly monitor average active sessions. Polling the Performance Insights API from a Lambda function would work but introduces custom code and ongoing operational overhead, violating the "least administration" constraint.
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 the DBLoad metric in Amazon RDS Performance Insights?
Open an interactive chat with Bash
How does a CloudWatch alarm monitor metrics like DBLoad effectively?
Open an interactive chat with Bash
What role does the Amazon SNS topic play in conjunction with a CloudWatch alarm?
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 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .