AWS Certified Solutions Architect – Associate (SAA-C02) — Question 331

A company is building a payment application that must be highly available even during regional service disruptions. A solutions architect must design a data storage solution that can be easily replicated and used in other AWS Regions. The application also requires low-latency atomicity, consistency, isolation, and durability (ACID) transactions that need to be immediately available to generate reports The development team also needs to use SQL.
Which data storage solution meets these requirements?

Answer options

• A. Amazon Aurora Global Database
• B. Amazon DynamoDB global tables
• C. Amazon S3 with cross-Region replication and Amazon Athena
• D. MySQL on Amazon EC2 instances with Amazon Elastic Block Store (Amazon EBS) snapshot replication

Correct answer: A

Explanation

Amazon Aurora Global Database is the ideal choice because it provides cross-Region replication, supports low-latency ACID transactions, and allows developers to run SQL queries. Amazon DynamoDB is a NoSQL database and does not support native SQL, while Amazon S3 with Amazon Athena is not designed for low-latency transactional writes. Deploying MySQL on Amazon EC2 with Amazon EBS snapshot replication introduces high operational overhead and does not easily support immediate, low-latency global transactions.