A SysOps administrator manages an Amazon RDS for MySQL instance that experiences high CPU utilization during business hours. The application is read-heavy. Which action will most effectively improve performance and reduce cost?
Trap 1: Enable Multi-AZ deployment.
Incorrect. Multi-AZ provides high availability and failover, but does not reduce CPU utilization on the primary instance.
Trap 2: Scale up the instance size to a larger instance class.
Incorrect. Scaling up increases performance but also increases cost, and does not optimize cost.
Trap 3: Enable automated backups.
Incorrect. Automated backups enable point-in-time recovery but do not reduce CPU usage.
- A
Enable Multi-AZ deployment.
Why wrong: Incorrect. Multi-AZ provides high availability and failover, but does not reduce CPU utilization on the primary instance.
- B
Scale up the instance size to a larger instance class.
Why wrong: Incorrect. Scaling up increases performance but also increases cost, and does not optimize cost.
- C
Add a read replica.
Correct. Read replicas handle read traffic, reducing load on the primary instance and improving performance cost-effectively.
- D
Enable automated backups.
Why wrong: Incorrect. Automated backups enable point-in-time recovery but do not reduce CPU usage.