Q35 — AWS SAP-C02 Ch.3

Question 35 of 75 | ← Chapter 3

Q260. A company hosts a web application on AWS in the us-east-1 Region. The application servers are distributed across three Availability Zones behind an Application Load Balancer. The database is hosted in MYSQL database on an Amazon EC2 instance. A solutions architect needs to design a cross-Region data recovery solution using AWS services with an RTO of less than 5 minutes and an RPO of less than 1 minute. The solutions architect is deploying application servers in us-west- 2, and has configured Amazon Route 53 health checks and DNS failover to us-west-2. Which additional step should the solutions architect take?

Correct Answer: B. Migrate the database to an Amazon Aurora global database with the primary in us-east-1 and the secondary in us-west-2.

Explanation

An Amazon Aurora global database is a collection of Aurora Replicas, each spanning one or more AWS Regions, that replicates data between AWS Regions asynchronously. The primary instance performs writes and all the replicas perform reads. In this case, migrating the database to an Amazon Aurora global database with the primary in us-east-1 and the secondary in us-west-2 will fulfill the cross-Region data recovery solution using AWS services with an RTO of less than 5 minutes and an RPO of less than 1 minute. The application servers are already deployed in us-west-2, and Amazon Route 53 health checks and DNS failover have been configured to us-west-2. Using Aurora global database, the read traffic can automatically be rerouted to the Aurora Replica located in us-west-2 in case of any failure in the primary region. The failover process takes typically less than a minute. Option A: Migrating the database to an Amazon RDS for MySQL instance with a cross-Region read replica in us-west-2 can provide cross-Region data recovery, but it does not meet the RTO and RPO requirements specified in the question. Option C: Migrating the database to an Amazon RDS for MySQL instance with a Multi-AZ deployment provides high availability within a Region but does not provide cross-Region data recovery. Option D: Creating a MySQL standby database on an Amazon EC2 instance in us-west-2 requires custom scripting and does not offer the benefits of managed services. An Aurora global database is a better option for cross-Region data recovery.