ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 416 - SOA-C02 discussion

Report
Export

The company needs a solution to provide failover for a Single-AZ RDS for MySQL DB instance to minimize application downtime.

A.

Modify the DB instance to be a Multi-AZ DB instance deployment.

Answers
A.

Modify the DB instance to be a Multi-AZ DB instance deployment.

B.

Add a read replica in the same Availability Zone where the DB instance is deployed.

Answers
B.

Add a read replica in the same Availability Zone where the DB instance is deployed.

C.

Add the DB instance to an Auto Scaling group that has a minimum capacity of 2 and a desired capacity of 2.

Answers
C.

Add the DB instance to an Auto Scaling group that has a minimum capacity of 2 and a desired capacity of 2.

D.

Use RDS Proxy to configure a proxy in front of the DB instance.

Answers
D.

Use RDS Proxy to configure a proxy in front of the DB instance.

Suggested answer: A

Explanation:

Modifying the DB instance to a Multi-AZ deployment is the recommended solution for failover and high availability in RDS. Multi-AZ RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone, allowing automatic failover in case of an instance or Availability Zone failure.

Multi-AZ Deployment: Provides resilience with automatic failover and minimizes application downtime.

No Application Changes Needed: Multi-AZ is managed by AWS, so the failover is transparent to the application.

Read replicas and Auto Scaling groups do not provide automatic failover for write operations, and RDS Proxy only improves connection management rather than high availability.

asked 06/11/2024
Mario Herrera González
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first