AWS Certified Database – Specialty — Question 15

A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS- specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?

Answer options

• A. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
• B. Enable cross-Region read replicas and direct read traffic to them when Amazon RDS is down
• C. Enable a read replica and direct read traffic to it when Amazon RDS is down
• D. Enable an Amazon RDS for MySQL Multi-AZ configuration

Correct answer: D

Explanation

The correct answer is D, as enabling an Amazon RDS for MySQL Multi-AZ configuration provides high availability and automatic failover, minimizing downtime during maintenance. Options A and B involve more complex migrations or setups that may incur higher costs and do not directly address the downtime issue. Option C also does not provide the same level of reliability as a Multi-AZ configuration.