AWS Certified Database – Specialty — Question 160

A company uses a single-node Amazon RDS for MySQL DB instance for its production database. The DB instance runs in an AWS Region in the United States.
A week before a big sales event, a new maintenance update is available for the DB instance. The maintenance update is marked as required. The company wants to minimize downtime for the DB instance and asks a database specialist to make the DB instance highly available until the sales event ends.
Which solution will meet these requirements?

Answer options

• A. Defer the maintenance update until the sales event is over.
• B. Create a read replica with the latest update. Initiate a failover before the sales event.
• C. Create a read replica with the latest update. Transfer all read-only traffic to the read replica during the sales event.
• D. Convert the DB instance into a Multi-AZ deployment. Apply the maintenance update.

Correct answer: D

Explanation

The correct answer is D because converting the DB instance to a Multi-AZ deployment enhances availability and provides failover capability during maintenance updates, minimizing downtime. Option A is incorrect as deferring the update does not address high availability. Option B is not suitable since a read replica does not provide the same level of availability as Multi-AZ during maintenance. Option C only addresses read traffic and does not ensure overall availability during the update.