A company has an Amazon RDS for MySQL DB instance that is configured as a Single-AZ DB instance. A SysOps administrator must configure the DB instance to fail over automatically in the event of a…

The correct answer is B. Modify the DB instance to be a Multi-AZ DB instance. Converting the DB instance to a Multi-AZ deployment will automatically provision a synchronous standby replica in a different Availability Zone. This configuration allows Amazon RDS to perform an automatic failover to the standby replica in the event of a failure of the primary…

Submitted by helene.fr· Mar 30, 2026Reliability and Business Continuity

Question

A company has an Amazon RDS for MySQL DB instance that is configured as a Single-AZ DB instance. A SysOps administrator must configure the DB instance to fail over automatically in the event of a failure. Which action will meet this requirement?

Options

AChange the DB instance to an RDS for PostgreSQL DB instance.
BModify the DB instance to be a Multi-AZ DB instance.
CCreate a read replica of the DB instance.
DEnable automated backups for the DB instance.

How the community answered

(29 responses)

A
7% (2)
B
76% (22)
C
3% (1)
D
14% (4)

Explanation

Converting the DB instance to a Multi-AZ deployment will automatically provision a synchronous standby replica in a different Availability Zone. This configuration allows Amazon RDS to perform an automatic failover to the standby replica in the event of a failure of the primary instance, thereby meeting the requirement for automatic failover.

Topics

#RDS Multi-AZ#automatic failover#high availability#RDS MySQL

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice