AWS Certified Database – Specialty — Question 198
A database specialist is planning to migrate a MySQL database to Amazon Aurora. The database specialist wants to configure the primary DB cluster in the us-west-2 Region and the secondary DB cluster in the eu-west-1 Region. In the event of a disaster recovery scenario, the database must be available in eu-west-1 with an RPO of a few seconds. Which solution will meet these requirements?
Answer options
- A. Use Aurora MySQL with the primary DB cluster in us-west-2 and a cross-Region Aurora Replica in eu-west-1
- B. Use Aurora MySQL with the primary DB cluster in us-west-2 and binlog-based external replication to eu-west-1
- C. Use an Aurora MySQL global database with the primary DB cluster in us-west-2 and the secondary DB cluster in eu-west-1
- D. Use Aurora MySQL with the primary DB cluster in us-west-2. Use AWS Database Migration Service (AWS DMS) change data capture (GDC) replication to the secondary DB cluster in eu-west-1
Correct answer: C
Explanation
The correct answer is C because an Aurora MySQL global database allows for low-latency global reads and provides a high availability solution with an RPO of a few seconds. Options A and B involve configurations that do not meet the stringent RPO requirements, while option D relies on AWS DMS, which may not provide the same level of efficiency and speed for disaster recovery scenarios.