SAP-C02 Question 128
Single answerA company is running a mission-critical, multi-region application on Amazon Web Services. The application requires a relational database for its backend and must have automatic failover capabilities, low latency, and the ability to handle high transaction rates globally. Which solution should you recommend to meet these requirements?
- A
Deploy Amazon RDS with Multi-AZ in one region and use cross-region read replicas for global reads.
- B
Use Amazon Aurora Global Database with primary and secondary clusters in different regions.
- C
Deploy Amazon DynamoDB with global tables to replicate data across regions.
- D
Use Amazon Redshift with cross-region snapshots for global data replication.
Show answer and explanation
Correct answer: B
Explanation
Amazon Aurora Global Database is the most appropriate solution for this scenario because it is a relational database service that supports globally distributed applications. It offers low-latency reads with secondary clusters in multiple regions, high transaction throughput, and automatic failover for disaster recovery, making it ideal for mission-critical applications.
- A. Incorrect.
Amazon RDS with Multi-AZ provides high availability within a single region and cross-region read replicas for global reads. However, it does not offer global failover or low latency for high transaction rates across regions.
- B. Correct.
Amazon Aurora Global Database is specifically designed for globally distributed applications. It provides a primary cluster in one region and secondary read-only clusters in other regions, ensuring low latency and high availability with automatic failover.
- C. Incorrect.
Amazon DynamoDB with global tables is a NoSQL solution, which is not suitable for relational database requirements as specified in the scenario.
- D. Incorrect.
Amazon Redshift is a data warehouse solution and is not designed for high-transaction, low-latency relational database workloads.