A SysOps Administrator manages an Amazon RDS MySQL DB instance in production. The database is accessed by several applications. The Administrator needs to ensure minimal downtime of the applications in the event the database suffers a failure. This change must not impact customer use during regular business hours. Which action will make the database MORE highly available?
A) Contact AWS Support to pre-warm the database to ensure that it can handle any unexpected spikes in traffic
B) Create a new Multi-AZ RDS DB instance. Migrate the data to the new DB instance and delete the old one
C) Create a read replica from the existing database outside of business hours
D) Modify the DB instance to outside of business hours to be a Multi-AZ deployment

Question

Quizplus · Accepted Answer

Creating a new Multi-AZ RDS DB instance will make the database more highly available because it will create a standby replica in a different Availability Zone. If the primary database fails, the standby replica will automatically take over, ensuring minimal downtime for the applications.

A SysOps Administrator Manages an Amazon RDS MySQL DB Instance