Exam AWS Certified Solutions Architect - Professional SAP-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional SAP-C02 exam

Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 76 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional SAP-C02

Question #: 76
Topic #: 1

[All AWS Certified Solutions Architect - Professional SAP-C02 Questions]

A retail company is hosting an ecommerce website on AWS across multiple AWS Regions. The company wants the website to be operational at all times for online purchases. The website stores data in an Amazon RDS for MySQL DB instance.

Which solution will provide the HIGHEST availability for the database?

A. Configure automated backups on Amazon RDS. In the case of disruption, promote an automated backup to be a standalone DB instance. Direct database traffic to the promoted DB instance. Create a replacement read replica that has the promoted DB instance as its source.
B. Configure global tables and read replicas on Amazon RDS. Activate the cross-Region scope. In the case of disruption, use AWS Lambda to copy the read replicas from one Region to another Region.
C. Configure global tables and automated backups on Amazon RDS. In the case of disruption, use AWS Lambda to copy the read replicas from one Region to another Region.
D. Configure read replicas on Amazon RDS. In the case of disruption, promote a cross-Region and read replica to be a standalone DB instance. Direct database traffic to the promoted DB instance. Create a replacement read replica that has the promoted DB instance as its source.

Show Suggested Answer

Suggested Answer: D 🗳️

by masetromain at Jan. 14, 2023, 5:30 p.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

zejou1

Highly Voted 2 years, 4 months ago

Selected Answer: D

This really should be multi-az but you could move to it w/ D. Here is the key to this one though; Highest Availability - the read replica is an asynchronous copy, while backup is a "time". Easier to do the read replica, and flip the switches than to reload from backup. Global Tables relate to DynomoDB https://disaster-recovery.workshop.aws/en/services/databases/dynamodb/dynamo-global-table.html Little handy "DR" guide

upvoted 15 times

...

princajen

Most Recent 2 weeks ago

Selected Answer: D

Automated Backups: Good for recovery, but restoring from backup is slow and not instant. Read Replicas: Can be in another Region. You can promote a read replica to be a standalone DB in case of a failover. Global Tables: Only available for DynamoDB, not RDS — this rules out any option mentioning global tables in the context of RDS.

upvoted 1 times

...

amministrazione

11 months, 1 week ago

D. Configure read replicas on Amazon RDS. In the case of disruption, promote a cross-Region and read replica to be a standalone DB instance. Direct database traffic to the promoted DB instance. Create a replacement read replica that has the promoted DB instance as its source.

upvoted 1 times

...

ninomfr64

1 year, 6 months ago

Selected Answer: D

A = you cannot promote an automated backup to a standalone DB (you restore a backup into a new DB instance instead). Creating a read replica could help in this scenario in case it is cross-region. This is not specified B = RDS does not support global table, copying a read replicas from a region to another make no sense to me C = see B D = correct

upvoted 1 times

...

NikkyDicky

2 years, 1 month ago

Selected Answer: D

D for sure

upvoted 1 times

...

rbm2023

2 years, 2 months ago

Selected Answer: D

There is Aurora Global Database, DynamoDB Global Tables and the question is about RDS for MySQL DB Instance. https://jayendrapatil.com/aws-aurora-global-database-vs-dynamodb-global-tables/ So, options B and C are not acceptable. Option D refers to using a cross-region replication for disaster recovery which can be found here https://disaster-recovery.workshop.aws/en/services/databases/rds/rds-cross-region.html Following article demonstrates a similar scenario using RDS for SQL Server https://aws.amazon.com/blogs/database/use-cross-region-read-replicas-with-amazon-relational-database-service-for-sql-server/ The design seems to be what we are looking in terms of option D. https://d2908q01vomqb2.cloudfront.net/887309d048beef83ad3eabf2a79a64a389ab1c9f/2022/11/15/dbblog-2614-image001.png

upvoted 2 times

...

mfsec

2 years, 4 months ago

Selected Answer: D

D makes the most sense

upvoted 1 times

...

God_Is_Love

2 years, 5 months ago

Selected Answer: D

No global tables concept in RDS, B,C are eliminated. A is wrong in terms of backing up Db copy to a standalone instance ? D provides read replicas for reading and also swtiches as a failiover in times of disruption and becomes primary. this is how HA can be maintained. D is correct.

upvoted 3 times

...

spd

2 years, 5 months ago

Selected Answer: D

MySQL - Read Replica. In this case, this is not aurora so not the global table option and hence can not be B and C

upvoted 2 times

...

sambb

2 years, 5 months ago

I haven't found any information about a "global table" for RDS. Global tables are for DynamoDB. For Aurora, it's called "global databases". RDS for MySQL supports cross-region read replicas https://aws.amazon.com/fr/blogs/aws/cross-region-read-replicas-for-amazon-rds-for-mysql/, so D has a better availability than A.

upvoted 2 times

...

icassp

2 years, 6 months ago

Selected Answer: D

for B,C, Amazon RDS does not support global tables yet. Only Aurora supports.

upvoted 4 times

AlanKrish

2 years, 5 months ago

Is Aurora not part of RDS? You can choose Aurora's compatibility with MySQL and PostreSQL).

upvoted 1 times

...

zhangyu20000

2 years, 6 months ago

D is correct

upvoted 3 times

masetromain

2 years, 6 months ago

https://www.examtopics.com/discussions/amazon/view/69438-exam-aws-certified-solutions-architect-professional-topic-1/

upvoted 1 times

...

masetromain

2 years, 6 months ago

It is possible that some people may think that option D. Configure read replicas on Amazon RDS. In the case of disruption, promote a cross-Region and read replica to be a standalone DB instance. Direct database traffic to the promoted DB instance. Create a replacement read replica that has the promoted DB instance as its source. is the best solution, as it also utilizes read replicas and cross-Region promotion to minimize downtime. However, it is important to consider that while this solution provides high availability, it doesn't provide the same level of automatic replication that global tables do. In case of a disruption, there is a risk of data loss during the manual switchover. and also with option D, you are still working with a single point of failure, the primary database, while in option B you have multiple copies of your data distributed across different regions, so in case of a failure you can switch over to one of the replicas without loss of data.

upvoted 2 times

Shahul75

2 years, 6 months ago

B is not right. Only Aurora has global tables. RDS don't

upvoted 1 times

...

[Removed]

2 years, 5 months ago

Cant be B due to global tables, ReadReplicas are supported with RDS and other options of restoring from backup do not create high availability

upvoted 1 times

...

masetromain

2 years, 6 months ago

Selected Answer: B

The correct answer is option B. Configuring global tables and read replicas on Amazon RDS with the cross-Region scope enabled provides the highest availability for the database. In case of disruption, the company can use AWS Lambda to copy the read replicas from one Region to another Region, ensuring that the website remains operational at all times. This solution provides automatic failover across multiple regions and allows for fast recovery in case of a disruption. Option A involves promoting an automated backup to be a standalone DB instance and creating a replacement read replica that has the promoted DB instance as its source. This solution is less efficient since it requires manual intervention and additional steps to promote the backup and create a replacement read replica.

upvoted 2 times

Sarutobi

2 years, 5 months ago

If the disruption is an outage that takes the Region offline completely, how could we use Lambda to copy the read replica from the Region that is no longer available to the backup to another Region?

upvoted 1 times

...

masetromain

2 years, 6 months ago

Option C involves configuring global tables and automated backups on Amazon RDS. This solution is less efficient since it does not provide automatic failover across multiple regions and requires additional steps to copy the read replicas from one Region to another Region using AWS Lambda. Option D involves configuring read replicas on Amazon RDS. In the case of disruption, promoting a cross-Region and read replica to be a standalone DB instance. This solution is less efficient than Option B since it does not provide automatic failover across multiple regions and requires manual intervention to promote the read replica to a standalone instance.

upvoted 1 times

bcx

2 years, 1 month ago

In fact global tables is a Dynamo DB thing. And RDS has Aurora Global Database. In this case Aurora is out of the question, it says RDS MySql, not Aurora (RDS) MySQL.

upvoted 1 times

...