Exam AWS Certified Solutions Architect - Professional All Questions

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

Exam AWS Certified Solutions Architect - Professional topic 1 question 46 discussion

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

Question #: 46
Topic #: 1

[All AWS Certified Solutions Architect - Professional Questions]

Your company has HQ in Tokyo and branch offices all over the world and is using a logistics software with a multi-regional deployment on AWS in Japan, Europe and USA. The logistic software has a 3-tier architecture and currently uses MySQL 5.6 for data persistence. Each region has deployed its own database.
In the HQ region you run an hourly batch process reading data from every region to compute cross-regional reports that are sent by email to all offices this batch process must be completed as fast as possible to quickly optimize logistics.
How do you build the database architecture in order to meet the requirements?

A. For each regional deployment, use RDS MySQL with a master in the region and a read replica in the HQ region
B. For each regional deployment, use MySQL on EC2 with a master in the region and send hourly EBS snapshots to the HQ region
C. For each regional deployment, use RDS MySQL with a master in the region and send hourly RDS snapshots to the HQ region
D. For each regional deployment, use MySQL on EC2 with a master in the region and use S3 to copy data files hourly to the HQ region
E. Use Direct Connect to connect all regional MySQL deployments to the HQ region and reduce network latency for the batch process

Show Suggested Answer

Suggested Answer: A 🗳️

by amog at Jan. 12, 2020, 3:57 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

amog

Highly Voted 3 years, 9 months ago

Answer is A "as fast as possible" => read replica

upvoted 12 times

...

student22

Most Recent 7 months, 3 weeks ago

Selected Answer: A

Answer: A NOT C - Having to manage MySQL on EC2 is too much overhead.

upvoted 1 times

...

amministrazione

10 months, 2 weeks ago

A. For each regional deployment, use RDS MySQL with a master in the region and a read replica in the HQ region

upvoted 1 times

...

JPA210

1 year, 4 months ago

Selected Answer: A

Definitely A, the least complex, it is easy to implement the read replicas for all the RDS DBs, the application can read from the read replica. D is not good, having to manage the MySQL on EC2, and I don't consider that s3 is important here. 'Logistic optimization'? What is that?! For ones that say that read-replica is regional check this https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.html

upvoted 1 times

...

tototo12

1 year, 5 months ago

Selected Answer: D

A is not possible because read replica should be in the same region as the master

upvoted 1 times

...

kondratyevmn

1 year, 11 months ago

Selected Answer: D

:) Are you reading a question at all? D. A - possibly, but no s3 as in option D, which address the logistic optimization requirement. B - no, as no point to use self managed MySQL on EC2, A better, but don't address the logistic optimization requirement. C - no, as A is better offers read replicas, which is better for DB performance, although it's not the ask. The ask is logistic optimization. D - possibly not the best to use self managed MySQL on EC2, but s3 usage is a good solution for logistic optimization. E - no, Direct Connect makes sense to connect on-premise resources with Cloud. Here, all of the resources are deployed in the Cloud already.

upvoted 1 times

shammous

1 year, 5 months ago

"but no s3 as in option D, which addresses the logistic optimization requirement." How does it address it, my friend? Would it be better for the batch job to query data from different read-replicas from each region in the HQ region, or extract data from files inside S3? It seems to me that the first option is more "optimal" and "fast"..

upvoted 1 times

...

rtguru

2 years, 1 month ago

Read replica seems to be the quickest way to get data from regions to headquarters. A is the correct answer

upvoted 1 times

kondratyevmn

1 year, 11 months ago

:) How so? You can't write to the read replica, because it's read only)

upvoted 1 times

...

ashii007

2 years, 8 months ago

A implies - read replica in a different region that region of master. AWS RDS mysql supports multi -AZ deployment ONLY. It cannot span across multiple regions.

upvoted 2 times

fdpv

2 years, 2 months ago

Please, check you facts: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RDS_Fea_Regions_DB-eng.Feature.CrossRegionReadReplicas.html The only objection could be that MySQL 5.6 is mentioned in the question. But for MySQL 5.6 and 8.0, cross-region read replicas with RDS for MySQL is supported. Maybe the question is somehow outdate.

upvoted 1 times

...