A company runs a critical database on Amazon RDS for MySQL. They need to ensure the database remains available even if an entire Availability Zone goes offline. What is the MOST operationally efficient way to achieve this?

Answer options:

Create a Read Replica in another Availability Zone.

Enable Multi-AZ deployment for the RDS instance.

Take hourly automated snapshots of the RDS instance.

Migrate the database to Amazon EC2 and configure clustering.

How to approach this question

Look for 'RDS high availability' and 'Availability Zone offline'. Multi-AZ is the native solution.

Full Answer

B.Enable Multi-AZ deployment for the RDS instance.✓ Correct

Amazon RDS Multi-AZ deployments provide high availability and failover support for DB instances. AWS automatically provisions and maintains a synchronous standby replica in a different Availability Zone.

Common mistakes

Confusing Read Replicas (performance) with Multi-AZ (high availability).

Question 19 All questions Question 21

Practice the full AWS SAA-C03 Practice Exam 3

65 questions · hints · full answers · grading

More questions from this exam

Q01A company stores sensitive documents in an Amazon S3 bucket. The security team requires that only...Easy Q02A large enterprise uses AWS Organizations to manage multiple accounts. The security team wants to...Medium Q03A company hosts a web application on Amazon EC2 instances behind an Application Load Balancer (AL...Easy Q04A company wants to continuously monitor its AWS accounts for malicious activity and unauthorized ...Medium Q05A company needs to encrypt data at rest in Amazon RDS and manage database credentials securely. T...Medium

View all 65 questions →