AWS Certified SysOps Administrator – Associate (legacy) — Question 488

A company runs an application that uses Amazon RDS for MySQL. During load testing of equivalent production volumes, the Development team noticed a significant increase in query latency. A SysOps Administrator concludes from investigating Amazon CloudWatch Logs that the CPU utilization on the RDS MySQL instance was at 100%.
Which action will resolve this issue?

Answer options

• A. Configure AWS Database Migration Service (AWS DMS) to allow Amazon RDS for MySQL to scale and accept more requests.
• B. Configure RDS for MySQL to scale horizontally by adding additional nodes to offload write requests.
• C. Enable the Multi-AZ feature for the RDS instance.
• D. Modify the RDS MySQL instance so it is a larger instance type.

Correct answer: D

Explanation

Scaling the RDS MySQL instance to a larger instance type (vertical scaling) provides more CPU and memory resources to handle the high workload. AWS DMS is used for database migration, not auto-scaling, and Multi-AZ only provides high availability without increasing compute capacity. RDS for MySQL does not support horizontal scaling for write operations; read replicas can only offload read traffic, not write traffic.