nerdexam
Amazon

SOA-C02 · Question #627

A company has an application that runs on Amazon EC2 instances. The application stores data on an Amazon RDS for MySQL Single-AZ DB instance. Requests to the DB instance from the application include…

The correct answer is A. Modify the DB instance to be a Multi-AZ DB instance deployment. Upgrading the DB instance to a Multi-AZ deployment ensures that a synchronous standby is maintained in another Availability Zone. In the event of a failure, RDS automatically fails over to the standby instance, minimizing downtime and ensuring high availability for the…

Submitted by krish.m· Mar 30, 2026Reliability and Business Continuity

Question

A company has an application that runs on Amazon EC2 instances. The application stores data on an Amazon RDS for MySQL Single-AZ DB instance. Requests to the DB instance from the application include reads and writes. A SysOps administrator must implement a solution that provides failover for the DB instance. The solution must minimize application downtime. Which solution will meet these requirements?

Options

  • AModify the DB instance to be a Multi-AZ DB instance deployment.
  • BAdd a read replica in the same Availability Zone where the DB instance is deployed.
  • CAdd the DB instance to an Auto Scaling group that has a minimum capacity of 2 and a desired
  • DUse RDS Proxy to configure a proxy in front of the DB instance.

How the community answered

(34 responses)
  • A
    79% (27)
  • B
    3% (1)
  • C
    12% (4)
  • D
    6% (2)

Explanation

Upgrading the DB instance to a Multi-AZ deployment ensures that a synchronous standby is maintained in another Availability Zone. In the event of a failure, RDS automatically fails over to the standby instance, minimizing downtime and ensuring high availability for the application.

Topics

#RDS Multi-AZ#automatic failover#database resilience#minimum downtime

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice