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

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?

Answer options

• 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

Correct answer: D

Explanation

Modifying an existing Single-AZ Amazon RDS instance to a Multi-AZ deployment is a seamless process that provides high availability and automatic failover. Scheduling this modification outside of business hours prevents any potential performance degradation from impacting active users during the initial data replication phase. Creating a new instance and migrating data (Option B) introduces unnecessary complexity and potential downtime, while read replicas (Option C) do not support automatic failover.