Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 450 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02

Question #: 450
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company's database is hosted on an Amazon Aurora MySQL DB cluster in the us-east-1 Region. The database is 4 TB in size. The company needs to expand its disaster recovery strategy to the us-west-2 Region. The company must have the ability to fail over to us-west-2 with a recovery time objective (RTO) of 15 minutes.
What should a solutions architect recommend to meet these requirements?

A. Create a Multi-Region Aurora MySQL DB cluster in us-east-1 and use-west-2. Use an Amazon Route 53 health check to monitor us-east-1 and fail over to us- west-2 upon failure.
B. Take a snapshot of the DB cluster in us-east-1. Configure an Amazon EventBridge (Amazon CloudWatch Events) rule that invokes an AWS Lambda function upon receipt of resource events. Configure the Lambda function to copy the snapshot to us-west-2 and restore the snapshot in us-west-2 when failure is detected.
C. Create an AWS CloudFormation script to create another Aurora MySQL DB cluster in us-west-2 in case of failure. Configure an Amazon EventBridge (Amazon CloudWatch Events) rule that invokes an AWS Lambda function upon receipt of resource events. Configure the Lambda function to deploy the AWS CloudFormation stack in us-west-2 when failure is detected.
D. Recreate the database as an Aurora global database with the primary DB cluster in us-east-1 and a secondary DB cluster in us-west-2. Configure an Amazon EventBridge (Amazon CloudWatch Events) rule that invokes an AWS Lambda function upon receipt of resource events. Configure the Lambda function to promote the DB cluster in us-west-2 when failure is detected.

Show Suggested Answer

Suggested Answer: D 🗳️

by henry_x at May 31, 2021, 11:42 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Gats

Highly Voted 3 years, 9 months ago

D. https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/Concepts.AuroraHighAvailability.html For high availability across multiple Amazon Regions, you can set up Aurora global databases. Each Aurora global database spans multiple Amazon Regions, enabling low latency global reads and disaster recovery from outages across an Amazon Region. Aurora automatically handles replicating all data and updates from the primary Amazon Region to each of the secondary Regions.

upvoted 34 times

Gats

3 years, 8 months ago

While a default Aurora cluster gives you failover capabilities within the Region, Aurora Global Database allows you to failover to a secondary cluster in a different Region.

upvoted 2 times

...

mahdeo01

3 years, 8 months ago

Yes, Answer has to be D because there is no concept as "Multi-Region Aurora" ..... There is only one thing called - "Aurora Global DB" and the sole purpose of this DB is to build fault tolerance against regional failure !!! " Amazon Aurora global databases span multiple Amazon Regions, enabling low latency global reads and providing fast recovery from the rare outage that might affect an entire Amazon Region. An Aurora global database has a primary DB cluster in one Region, and up to five secondary DB clusters in different Regions." Link>> https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html

upvoted 9 times

DahMac

3 years, 8 months ago

You can create an Amazon Aurora MySQL DB cluster as a read replica in a different AWS Region than the source DB cluster. Taking this approach can improve your disaster recovery capabilities, let you scale read operations into an AWS Region that is closer to your users, and make it easier to migrate from one AWS Region to another. You can create read replicas of both encrypted and unencrypted DB clusters. The read replica must be encrypted if the source DB cluster is encrypted. For each source DB cluster, you can have up to five cross-Region DB clusters that are read replicas. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Replication.CrossRegion.html

upvoted 2 times

DahMac

3 years, 8 months ago

I found no instances of needing lambda or EventBridge for failover. That makes the answer -A-

upvoted 2 times

...

etheng1970

2 years, 12 months ago

There is a Multi-Regional Aurora =>https://aws.amazon.com/blogs/database/deploy-multi-region-amazon-aurora-applications-with-a-failover-blueprint/

upvoted 1 times

...

henry_x

Highly Voted 3 years, 9 months ago

A. i would go with A.

upvoted 10 times

...

BECAUSE

Most Recent 2 years ago

Selected Answer: D

D is the answer

upvoted 1 times

...

andersonneo

2 years, 10 months ago

Selected Answer: A

Aurora Global DB should not require Lambda and Events bridge. Hence D seems incorrect

upvoted 2 times

...

Root_Access

2 years, 10 months ago

Selected Answer: D

Its D, full explanation here: https://aws.amazon.com/blogs/database/deploy-multi-region-amazon-aurora-applications-with-a-failover-blueprint/

upvoted 1 times

...

cloud_collector

2 years, 10 months ago

B is NOT correct. Cold backups are the lowest cost option, but come with the longest RTO and RPO. You need to take a backup and restore it to a new instance before the database is back online. https://aws.amazon.com/blogs/database/how-to-choose-the-best-disaster-recovery-option-for-your-amazon-aurora-mysql-cluster/

upvoted 1 times

cloud_collector

2 years, 10 months ago

Rather than relying on backups or snapshots to make data available in another Region, a global database takes the proven storage-level physical replication technology of Aurora and applies it across Regions. This enables low-latency global reads and provides fast recovery from an unlikely event that could affect an entire Region. An Aurora global database has a primary DB cluster in one Region, and up to five secondary DB clusters in different Regions. D is better for less RTO in few minutes

upvoted 1 times

...

Dimkaaa

2 years, 10 months ago

Selected Answer: D

After reviewing this article https://aws.amazon.com/blogs/database/how-to-choose-the-best-disaster-recovery-option-for-your-amazon-aurora-mysql-cluster/ I go with D. Here are the main points in my opinion: A - "RTO is typically a few minutes, but also dependent on replication delay." So I think RTO can be more than 15 min. D - "This provides for an RPO of typically less than a second, and an RTO of a few minutes." A few minutes, in any case, so I go with D.

upvoted 2 times

...

NourALdeen

2 years, 11 months ago

Selected Answer: D

DDDDDDDDD

upvoted 2 times

...

kiko_zhang

2 years, 11 months ago

Selected Answer: A

agree with A

upvoted 1 times

...

Nachiket_22_91

2 years, 11 months ago

Selected Answer: D

The answer is D. There is nothing called Multi-AZ Aurora "Cluster", only Multi AZ Read Replicas. These read replicas can be promoted to a standalone DB cluster in case of failover. Option A,B, and C doesn't mention the Read Replica Hence the only option left is D where failover across regions will be achieved

upvoted 1 times

...

Red8aron

2 years, 11 months ago

Selected Answer: D

We recommend that you understand this process before using it. Have a plan ready to quickly proceed at the first sign of a Region-wide issue. Be ready to identify the secondary Region with the least lag time. Use Amazon CloudWatch regularly to track lag times for the secondary clusters. Make sure to test your plan to check that your procedures are complete and accurate, and that staff are trained to perform a DR failover before it really happens.

upvoted 2 times

...

Ashu_0007

2 years, 11 months ago

Selected Answer: A

100% A. Route53 will do the endpoint change in CNAME

upvoted 1 times

...

Tonero2016

2 years, 11 months ago

The answer is A

upvoted 1 times

...

etheng1970

2 years, 12 months ago

Selected Answer: A

A => https://aws.amazon.com/blogs/database/deploy-multi-region-amazon-aurora-applications-with-a-failover-blueprint/

upvoted 1 times

imurilloh

2 years, 10 months ago

To implement this solution, you need an Aurora cluster (with Aurora Global Database) running in the primary and secondary Regions.

upvoted 1 times

...

ysyau

3 years ago

Selected Answer: A

it has to be A. A solution without patching work from Lambda

upvoted 1 times

...

mazaukr

3 years ago

Selected Answer: D

D correct

upvoted 1 times

...

bighedgedog

3 years ago

Selected Answer: D

D is correct: https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html. A doesn't work because there's no concept of Aurora Multi-Region cluster (you need to use R53, DB replication and Lambda to achieve something similar to a Aurora Global DB).

upvoted 1 times

...

Load full discussion...