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

A user is using a small MySQL RDS DB. The user is experiencing high latency due to the Multi AZ feature. Which of the below mentioned options may not help the user in this situation?

Answer options

• A. Schedule the automated back up in non-working hours
• B. Use a large or higher size instance
• C. Use PIOPS
• D. Take a snapshot from standby Replica

Correct answer: D

Explanation

In an Amazon RDS Multi-AZ deployment, synchronous replication to the standby replica can cause write latency, particularly on smaller instances with constrained I/O. While upgrading the instance size, using Provisioned IOPS, and adjusting backup windows can mitigate performance issues, users cannot manually trigger a snapshot specifically from the standby replica to reduce this latency.