An architecture uses Amazon RDS for MySQL. The business requires that the database can survive an Availability Zone failure with zero data loss (RPO=0) and automatic failover. Which configuration is required?

Answer options:

Deploy an RDS Read Replica in a different AZ.

Deploy the RDS instance with Multi-AZ enabled.

Use AWS Database Migration Service (DMS) to replicate to another RDS instance.

Configure automated backups to run every 5 minutes.

How to approach this question

Identify the RDS feature that provides synchronous replication.

Full Answer

B.Deploy the RDS instance with Multi-AZ enabled.✓ Correct

Deploy the RDS instance with Multi-AZ enabled.

Amazon RDS Multi-AZ deployments provide high availability and failover support using synchronous storage replication, ensuring zero data loss (RPO=0).

Common mistakes

Confusing Read Replicas (asynchronous) with Multi-AZ (synchronous).

Question 28 All questions Question 30

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 6

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise requires highly available hybrid connectivity between its on-premises data ce...Hard Q02An organization has 50 VPCs across two AWS Regions connected via Transit Gateways (TGW). The TGWs...Hard Q03A company uses AWS Organizations. The network team wants to share a central Transit Gateway (TGW)...Medium Q04An enterprise has on-premises data centers in the US and Europe. They want to use the AWS global ...Hard Q05A company requires that all API calls to Amazon S3 from their VPC must not traverse the public in...Medium

View all 75 questions →