Courseiva
Question 463 of 247
Monitoring, Logging, and RemediationmediumMultiple ChoiceObjective-mapped

SOA-C02 Monitoring, Logging, and Remediation Practice Question

A SysOps administrator manages an Amazon RDS for MySQL instance that handles a critical web application. During peak traffic, the number of database connections exceeds 500 for more than 15 minutes, leading to connection timeouts. The administrator wants to automatically increase the DB instance size when the connection count remains high, and decrease it when the load drops, to balance performance and cost. Which combination of AWS services should be used to achieve this automation with the least operational overhead?

⚠ Common exam trap

Test-takers frequently confuse AWS Config rules (designed for compliance) with CloudWatch alarms (designed for metric monitoring), leading them to choose Option B, or they overcomplicate the solution with CloudFormation custom resources (Option A) or Systems Manager runbooks (Option D) when a simple Lambda function triggered by a CloudWatch alarm is the most direct and low-overhead approach.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Set up an Amazon CloudWatch alarm on the DatabaseConnections metric that triggers an AWS Lambda function to modify the DB instance class via the RDS API.

It uses a CloudWatch alarm to monitor the DatabaseConnections metric, which triggers an AWS Lambda function that directly calls the RDS ModifyDBInstance API to change the instance class. This approach provides the least operational overhead by leveraging native AWS services without additional infrastructure, custom resources, or periodic polling, and it enables real-time, event-driven scaling based on the specified threshold.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Configure a CloudWatch alarm on DatabaseConnections that triggers an Amazon CloudWatch Events rule, which directly modifies the DB instance class using a CloudFormation custom resource.

    Why it's wrong here

    Amazon CloudWatch Events (now EventBridge) does not have a direct target that can modify an RDS instance class; its targets are services like Lambda, SNS, and Systems Manager, not CloudFormation. A CloudFormation custom resource would require a separate trigger-handling Lambda or SNS function to perform the RDS ModifyDBInstance call, adding needless complexity and latency. This approach is not a supported pattern for real-time metric-driven scaling, and the custom resource lifecycle is designed for provisioning resources, not for making ad-hoc modifications to existing DB instances.

  • Use an AWS Config rule to monitor DatabaseConnections and invoke an AWS Lambda function to scale the RDS instance when the threshold is breached.

    Why it's wrong here

    AWS Config rules are designed to evaluate resource configuration attributes (such as tags, encryption, or backup settings) against compliance policies, not to process near-real-time CloudWatch metrics like DatabaseConnections. The DatabaseConnections value is emitted as a metric and is not a configuration property of the RDS instance, so a Config rule cannot directly observe it. Even a custom AWS Config rule would rely on configuration changes or a periodic schedule, making it unsuitable for responding immediately to connection-count threshold breaches.

  • Set up an Amazon CloudWatch alarm on the DatabaseConnections metric that triggers an AWS Lambda function to modify the DB instance class via the RDS API.

    Why this is correct

    Correct: you create a CloudWatch alarm on DatabaseConnections with a threshold (e.g., high connections for 5 minutes); when it enters ALARM, it sends a notification to an SNS topic that triggers a Lambda function, or uses an alarm action to invoke Lambda directly. The Lambda function calls the RDS ModifyDBInstance API with the desired DBInstanceClass and the DBInstanceIdentifier, and RDS performs the scaling. This is an event-driven, low-latency pattern that requires no polling and is a supported, commonly used approach for automated RDS instance-class scaling.

  • Use an AWS Systems Manager Automation runbook to periodically check the DatabaseConnections metric and adjust the RDS instance class if needed.

    Why it's wrong here

    Systems Manager Automation runbooks require a trigger, such as a schedule or manual execution, and cannot continuously monitor a metric in real time; a periodic check means the scaling action will lag by the polling interval. You would have to create a custom runbook that first reads GetMetricData and then calls ModifyDBInstance, which is unnecessarily complex and still not event-driven. CloudWatch alarms provide immediate notification-based scaling, so relying on SSM Automation adds latency and complexity without any benefit for this use case.

Quick reference

Cloud Service Model Comparison

ModelYou ManageProvider ManagesExamples
IaaSOS, runtime, apps, dataHardware, hypervisor, networkingEC2, Azure VMs, GCP Compute Engine
PaaSApps and dataOS, runtime, middleware, hardwareElastic Beanstalk, Azure App Service
SaaSData and settings onlyEverything elseMicrosoft 365, Salesforce, Workday
FaaS / ServerlessFunction code onlyInfra, scaling, runtimeLambda, Azure Functions, Cloud Run
CaaSContainers and appsKubernetes, OS, hardwareEKS, AKS, GKE

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Last reviewed: Jun 11, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

Sign in to join the discussion.

This SOA-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SOA-C02 exam.