AWS Certified Solutions Architect Professional · Free Practice Question Hard
Question 1
A company is designing an application that will requires cross-Region disaster recovery with an RTO of less than 5 minutes and an RPO of less than 1 minute. The application tier DR solution has already been designed and a Solutions Architect must design the data recovery solution for the MySQL database tier.
How should the database tier be configured to meet the data recovery requirements?
-
A
Use an Amazon RDS for MySQL instance with a Multi-AZ deployment.
-
B
Use an Amazon Aurora global database with the primary in the active Region and the secondary in the failover Region.
-
C
Use an Amazon RDS for MySQL instance with a cross-Region read replica in the failover Region.
-
D
Create an Amazon RDS instance in the active Region and use a MySQL standby database on an Amazon EC2 instance in the failover Region.
Reveal correct answer
Correct answer: B
Explanation
Amazon Aurora Global Database is designed for globally distributed applications, allowing a single Amazon Aurora database to span multiple AWS regions. It replicates your data with no impact on database performance, enables fast local reads with low latency in each region, and provides disaster recovery from region-wide outages.
This solution will meet the Recovery Time Objective (RTO) of less than 5 minutes and Recovery Point Objective (RPO) of less than 1 minute.
CORRECT: "Use an Amazon Aurora global database with the primary in the active Region and the secondary in the failover Region" is the correct answer.
INCORRECT: "Use an Amazon RDS for MySQL instance with a cross-Region read replica in the failover Region" is incorrect. A read replica cannot be used as a writable database. It is possible to promote a read replica but this may not be fast enough to meet the RTO requirement.
INCORRECT: "Use an Amazon RDS for MySQL instance with a Multi-AZ deployment" is incorrect. You cannot have a Multi-AZ deployment that spans across AWS Regions.
INCORRECT: "Create an Amazon RDS instance in the active Region and use a MySQL standby database on an Amazon EC2 instance in the failover Region" is incorrect. You cannot configure a MySQL DB on EC2 to be a standby for an Amazon RDS DB instance.
References:
https://aws.amazon.com/rds/aurora/global-database/
Save time with our AWS cheat sheets:
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
