Which data storage solution meets these requirements?

By:
In: SAA-C02
Tagged:
With: 1 Comment
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?

Amazon Aurora Global Database

Amazon DynamoDB global tables

Amazon S3 with cross-Region replication and Amazon Athena

MySQL on Amazon EC2 instances with Amazon Elastic Block Store (Amazon EBS) snapshot replication

Explanations:

Amazon Aurora Global Database is designed for globally distributed applications and provides low-latency, ACID-compliant transactions with replication across AWS Regions.

Amazon DynamoDB global tables provide high availability and low-latency for NoSQL data, but they do not support ACID transactions or SQL.

Amazon S3 with cross-Region replication and Athena are suitable for big data analysis but do not support ACID transactions or low-latency SQL querying.

MySQL on EC2 with EBS snapshot replication does not provide automatic global replication or low-latency ACID transactions across Regions.

2025-10-06

1 Comment

  1. Teresa
    Author

    If memory serves me right, the answer is:
    Amazon Aurora Global Database

Leave a Reply to Teresa Cancel reply

Your email address will not be published. Required fields are marked *

4 × 2 =