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

D should be the answer. The problem is performance can be easily solved by using read replicas.

We could use "Cross-Region Read Replicas for Amazon RDS for MySQL" see https://aws.amazon.com/blogs/aws/cross-region-read-replicas-for-amazon-rds-for-mysql/ but there is no such option and and option C says " Deploy MySQL instances in each Region. Deploy an Application Load Balancer in front of MySQL to reduce the load on the primary instance." and we cannot do this since we cannot deploy instance to different region. though "Cross-Region Read Replicas for Amazon RDS for MySQL" are supported. So the oly option left is "Migrate the database to an Amazon Aurora global database in MySQL compatibility mode. Configure read replicas in one of the European Regions." i.e. D so D is the correct Answer.

A. (X)It is important to remember that each AWS Region is completely independent. D. Amazon Aurora global databases span multiple AWS Regions, enabling low latency global reads and providing fast recovery from the rare outage that might affect an entire AWS Region. An Aurora global database has a primary DB cluster in one Region, and up to five secondary DB clusters in different Regions. * Global reads with local latency * Scalable secondary Aurora DB clusters * Fast replication from primary to secondary Aurora DB clusters * Recovery from Region-wide outages https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html

D is right

Answer should be D, no other options.

Explanation: The issue here is latency with read queries being directed from Australia to UK which is great physical distance. A solution is required for improving read performance in Australia. An Aurora global database consists of one primary AWS Region where your data is mastered, and up to five read-only, secondary AWS Regions. Aurora replicates data to the secondary AWS Regions with typical latency of under a second. You issue write operations directly to the primary DB instance in the primary AWS Region.

D. Migrate the database to an Amazon Aurora global database in MySQL compatibility mode. Configure read replicas in one of the European Regions.

D is the correct answer. A--> Amazon RDS has regional significance. so, ruled out because of multi-region. B -> Changing baseline Db from MySql to DynamoDB is drastic design change. C -> Two database means inconsistent data. D- > only solves the multi-region and performance issue with read replica.

Why not C? My take on it is EU isn;t receiving the same query performance... but these querries aren't necessarily read query (Select), if they're write querries (e.g. Insert into) then how is a read replica helping?

D in neal

Well, I don't see any part of question stating the application is "query only", so I have doubt on "D"

D for sure since we are interested in perf not availability

Correct answer is D as Aurora Global Database provides low latency access to the data across regions. MySQL compatibility enables a seamless integration

it's D

Ans = D Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL are compatible.

D right

If there are more visits in Europe, ALB will allocate traffic to RDS in the United States, which will not improve performance