SAA-C03 Question #515: Real Exam Question with Answer & Explanation

Question

A company runs a critical Amazon RDS for MySQL DB instance in a single Availability Zone. The company must improve the availability of the DB instance. Which solution will meet this requirement?

Options

• AConfigure the DB instance to use a multi-Region DB instance deployment.
• BCreate an Amazon Simple Queue Service (Amazon SQS) queue in the AWS Region where the
• CConfigure the DB instance to use a Multi-AZ DB instance deployment.
• DCreate an Amazon Simple Queue Service (Amazon SQS) queue in a different AWS Region than

Explanation

To improve availability and fault tolerance of an Amazon RDS instance, the recommended approach is to configure a Multi-AZ deployment. Multi-AZ deployments for RDS automatically replicate data to a standby instance in a different Availability Zone (AZ). If a failure occurs in the primary AZ (due to hardware, network, or power), RDS will automatically failover to the standby instance with minimal downtime, without administrative intervention. This is an AWS-managed feature and does not require application modification. It does not provide scalability or load balancing; it's designed for high availability and resiliency. Options A, B, and D are incorrect: A refers to cross-Region, which is used for disaster recovery, not high availability. B and D with SQS do not address high availability directly for the RDS instance; queues help decouple systems but do not make a database more resilient.

No community discussion yet for this question.