SOA-C02 Monitoring, Logging, and Remediation Practice Question
A company uses Amazon RDS for MySQL and wants to monitor the number of database connections in real time. Which CloudWatch metric should the SysOps administrator use?
⚠ Common exam trap
Watch out — candidates often confuse the MySQL status variable `Threads_connected` (which maps to `DatabaseConnections`) with `Threads_running` (which counts only actively executing queries) or assume a generic name like `ActiveConnections` or `ConnectionCount` exists as a CloudWatch metric.
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
✓
DatabaseConnections
Amazon RDS for MySQL exposes a CloudWatch metric named `DatabaseConnections` that reports the number of client connections to the DB instance. This metric is derived from the MySQL `Threads_connected` status variable and is updated every minute, providing real-time visibility into connection counts for monitoring and alarming.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
DatabaseConnections
Why this is correct
DatabaseConnections is the correct standard CloudWatch metric because Amazon RDS publishes it in the AWS/RDS namespace as a gauge that reports the number of client network connections to the DB instance. It includes all active sessions from applications, readers, and management tools, and it is the authoritative counter to compare against the instance's max_connections, which varies by instance class and DB engine. This metric directly answers the question of how many concurrent connections are present.
- ✗
CPUUtilization
Why it's wrong here
CPUUtilization is wrong here because it gauges the percentage of allocated compute capacity consumed by the database engine, not the number of client connections. A single expensive query can drive CPU to 100% with only one connection, while hundreds of idle pooled connections can keep CPU near zero. It is useful for scaling and query tuning but cannot quantify or verify the connection count.
- ✗
ActiveConnections
Why it's wrong here
ActiveConnections is not a valid Amazon RDS CloudWatch metric name; the service only documents DatabaseConnections for tracking client connections in the AWS/RDS namespace. ActiveConnections appears inside MySQL performance_schema tables or through Enhanced Monitoring's process list output, but those sources require extra setup and are not exposed as default CloudWatch measurements. Relying on this name in a CloudWatch alarm would result in an invalid metric error.
- ✗
ConnectionCount
Why it's wrong here
ConnectionCount is not a published metric from the AWS/RDS namespace; standard RDS monitoring does not emit a dimension or metric with that exact name. To use it, you would have to define a custom metric by manually collecting current connection data and calling PutMetricData to publish under your own namespace. This adds unnecessary operational overhead and, unlike DatabaseConnections, is not automatically available for all RDS instances.
Go deeper
Related to this question
About these practice questions
One of 1,169 original SOA-C02 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.