SAA-C03 Question 25: Highly Available Relational Database

0
0

A finance app needs its RDS MySQL database to remain available if a single Availability Zone fails, with automatic recovery. Which configuration provides this?

A) A single-AZ RDS instance with frequent snapshots.

B) An RDS Multi-AZ deployment.

C) A read replica in the same AZ.

D) Storing the database on a single large EC2 instance.

Correct Answer: B

Explanation: RDS Multi-AZ maintains a synchronous standby in a different AZ and fails over automatically if the primary or its AZ fails. (A) snapshots allow restore but with downtime and data loss. (C) a same-AZ read replica neither survives an AZ failure nor auto-fails-over for writes. (D) self-managed on one instance has no HA.