exam questions

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

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 Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Gats
Highly Voted 3 years, 7 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, 6 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, 6 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, 6 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, 6 months ago
I found no instances of needing lambda or EventBridge for failover. That makes the answer -A-
upvoted 2 times
...
...
etheng1970
2 years, 10 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, 7 months ago
A. i would go with A.
upvoted 10 times
...
BECAUSE
Most Recent 1 year, 11 months ago
Selected Answer: D
D is the answer
upvoted 1 times
...
andersonneo
2 years, 8 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, 8 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, 8 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, 8 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, 8 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, 9 months ago
Selected Answer: D
DDDDDDDDD
upvoted 2 times
...
kiko_zhang
2 years, 9 months ago
Selected Answer: A
agree with A
upvoted 1 times
...
Nachiket_22_91
2 years, 9 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, 9 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, 9 months ago
Selected Answer: A
100% A. Route53 will do the endpoint change in CNAME
upvoted 1 times
...
Tonero2016
2 years, 9 months ago
The answer is A
upvoted 1 times
...
etheng1970
2 years, 10 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, 8 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
2 years, 10 months ago
Selected Answer: A
it has to be A. A solution without patching work from Lambda
upvoted 1 times
...
mazaukr
2 years, 10 months ago
Selected Answer: D
D correct
upvoted 1 times
...
bighedgedog
2 years, 10 months 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago