Q15 — AWS SAP-C02 Ch.3

Question 15 of 75 | ← Chapter 3

Q240. A company has deployed its database on an Amazon RDS for MySQL DB instance in the us-east-1 Region.The company needs to make its data available to customers in Europe.The customers in Europe must have access to the same data as customers in the United States (US) and will not tolerate high application latency or stale data. The customers in Europe and the customers in the US need to write to the database. Both groups of customers need to see updates from the other group in real time. Which solution will meet these requirements?

• A. Create an Amazon Aurora MySQL replica of the RDS for MySQL DB instance. Pause application writes to the RDS DB instance. Promote the Aurora Replica to a standalone DB cluster. Reconfigure the application to use the Aurora database anc resume writes. Add eu-west-1 as a secondary Region to the DB cluster.Enable write forwarding on the DB cluster. Deploy the application in eu-west-1. Configure the application to use the Aurora MySQL endpoint in eu-west-1
• B. Add a cross-Region replica in eu-west-1 for the RDS for MySQL DB instance. Configure the replica to replicate write queries back to the primary DB instance. Deploy the application in eu-west-1. Configure the application to use the RDS for MySQL endpoint in eu-west-1
• C. Copy the most recent snapshot from the RDS for MySQL DB instance to eu-west-1. Create a new RDS for MySQL DB instance in eu-west-1 from the snapshot. Configure MySQL logical replication from us- east-1 to eu-west-1. Enable write forwarding on the DB cluster. Deploy the application in eu-west- 1.Configure the application to use the RDS for MySQL endpoint in eu-west-
• D. Convert the RDS for MySQL DB instance to an Amazon Aurora MySQL DB cluster. Add eu-west-1 as a secondary Region to the DB cluster. Enable write forwarding on the DB cluster. Deploy the application in eu-west-1. Configure the application to use the Aurora MySQL endpoint in eu-west-1 ✓

Correct Answer: D. Convert the RDS for MySQL DB instance to an Amazon Aurora MySQL DB cluster. Add eu-west-1 as a secondary Region to the DB cluster. Enable write forwarding on the DB cluster. Deploy the application in eu-west-1. Configure the application to use the Aurora MySQL endpoint in eu-west-1

Explanation

Option A is incorrect because pausing writes to the RDS DB instance and promoting an Aurora Replica can be time-consuming. Also, write forwarding is not supported by Aurora. Option B is incorrect because cross-region replication of RDS for MySQL doesn't support writing in both regions, so customers in Europe won't be able to write to the database. Option C is an option but requires manual copying of data between regions using snapshots and logical replication configurations. Option D is the optimal solution. It involves converting the RDS MySQL DB instance to an Amazon Aurora MySQL DB cluster, which enables cross-region replication with minimal latency and no data loss. The eu- west-1 region is added as a secondary region to the DB cluster, enabling read and write access to the same data from both regions. Write forwarding is enabled on the DB cluster, which ensures that writes made in one region are also forwarded to the other region in real-time. Finally, the application is deployed in eu- west-1, configured to use the Aurora MySQL endpoint in that region.