What should a solutions architect recommend?

By:
In: SAA-C02
Tagged:
With: 2 Comments
A company with facilities in North America, Europe, and Asia is designing new distributed application to optimize its global supply chain and manufacturing process.The orders booked on one continent should be visible to all Regions in a second or less.The database should be able to support failover with a shortRecovery Time Objective (RTO).The uptime of the application is important to ensure that manufacturing is not impacted.

What should a solutions architect recommend?

Use Amazon DynamoDB global tables.

Use Amazon Aurora Global Database.

Use Amazon RDS for MySQL with a cross-Region read replica.

Use Amazon RDS for PostgreSQL with a cross-Region read replica.

Explanations:

While Amazon DynamoDB Global Tables provide global replication and low-latency read/write access across Regions, they are best suited for NoSQL databases rather than transactional applications needing strong consistency, making it less ideal for complex supply chain applications.

Amazon Aurora Global Database provides globally distributed and highly available storage, with low-latency replication across Regions, allowing for quick failover and a short RTO, which is ideal for transactional applications requiring near real-time global visibility and high uptime.

Amazon RDS for MySQL with cross-Region read replicas offers global read access but has higher replication latency and lacks the sub-second global data visibility and failover speed of Aurora Global Database, making it less ideal for this use case.

Amazon RDS for PostgreSQL with cross-Region read replicas also provides global read access, but it does not meet the low-latency global visibility requirement and may have slower recovery times than Aurora Global Database, making it less suitable.

2026-04-01

2 Comments

  1. Elijah
    Author

    Based on what I know, the answer is:
    Use Amazon Aurora Global Database.

  2. Martha
    Author

    I scheme that the answer is:
    Use Amazon Aurora Global Database.

Leave a Reply

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

14 − twelve =