A company is designing a highly available architecture for a new relational database. The database must support automatic failover in the event of an Availability Zone outage. The application requires a MySQL-compatible database engine. <br/><br/>Which TWO solutions meet these requirements? (Select TWO.)

Answer options:

Amazon RDS for MySQL with Multi-AZ deployments

Amazon RDS for MySQL with Read Replicas

Amazon Aurora MySQL-Compatible Edition

Amazon DynamoDB Global Tables

Amazon EC2 instances running MySQL with EBS snapshots

How to approach this question

Look for managed relational database services that support automatic failover.

Full Answer

Amazon RDS for MySQL with Multi-AZ deployments<br/>Amazon Aurora MySQL-Compatible Edition

Both Amazon RDS Multi-AZ deployments and Amazon Aurora provide high availability and automatic failover for relational databases. Aurora is inherently highly available, storing 6 copies of data across 3 AZs.

Common mistakes

Selecting Read Replicas, thinking they provide automatic failover.

Question 22 All questions Question 24

Practice the full AWS SAA-C03 Practice Exam 4

65 questions · hints · full answers · grading

More questions from this exam

Q01A company has multiple AWS accounts in an AWS Organizations organization. The security team wants...Medium Q02An application running on Amazon EC2 instances needs to access an Amazon DynamoDB table. Both res...Easy Q03A company is designing a web application that will be hosted on AWS. The application will use an ...Medium Q04A company is building a mobile app that requires users to authenticate using their social media a...Hard Q05A solutions architect is designing a VPC for a three-tier web application. The database tier must...Medium

View all 65 questions →