PrepAway - Latest Free Exam Questions & Answers

A user is using a small MySQL RDS DB. The user is experiencing high latency due to the Multi AZ feature. Which

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 no

t help the user in this situation?

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

Explanation:

An RDS DB instance which has enabled Multi

AZ deployments may experience increased write and commit latency compared to a Single AZ deployment, due to synchronous data replication. The user may also face changes in latency if deployment fails over to the standby replica. For production workloads, A

WS recommends the user to use provisioned IOPS and DB instance classes (m1.large and larger. as they are optimized for provisioned IOPS to give a fast, and consistent performance. With Multi AZ feature, the user can not have option to take snapshot from re

plica.


Leave a Reply

Your email address will not be published. Required fields are marked *