Examkin

Question

Difficulty: MediumResilient Database Configurations and High Availability

A gaming company is launching a real-time multiplayer game. Players in North America and Europe must read and write their profiles and game state data with sub-second latency. The system must remain highly available even if an entire AWS Region suffers an outage, with a Recovery Time Objective (RTO) of less than 1 minute and a Recovery Point Objective (RPO) of near 0. Which database configuration should a solutions architect recommend to satisfy these requirements?

  1. A
    Deploy an Amazon RDS for MySQL DB instance in North America with Multi-AZ enabled. Create a cross-region read replica in Europe. Configure the game servers in Europe to write directly to the read replica to reduce latency, and promote the replica manually if the North America region fails.
  2. B
    Deploy a single-region Amazon Aurora MySQL database in North America. Set up Amazon Route 53 latency-based routing to dynamically route write requests from Europe players to the North America database, relying on the latency routing policy to handle failover to a backup database in Europe if the primary region goes offline.
  3. Deploy an Amazon DynamoDB global table replicated between the North America and Europe regions. Use Amazon Route 53 latency-based routing combined with active health checks to direct user traffic to the closest healthy region.Answer
  4. D
    Deploy an Amazon Aurora PostgreSQL Global Database with the primary cluster in North America and a secondary cluster in Europe. Configure a Pilot Light disaster recovery strategy where the secondary Europe cluster is kept in a shut-down state and is only provisioned and scaled up when a regional failover is triggered.

Answer

The correct answer is the option that proposes deploying an Amazon DynamoDB global table replicated between the North America and Europe regions, along with Route 53 latency-based routing and health checks.
The correct answer is the option suggesting the deployment of an Amazon DynamoDB global table replicated between both regions using Route 53 latency-based routing and health checks. DynamoDB global tables support multi-region, active-active read and write operations. The data is replicated asynchronously with sub-second latency, providing near-zero RPO. Combined with Route 53 latency-based routing and health checks, client traffic is automatically routed to the closest healthy regional endpoint, allowing failover to complete in under a minute to satisfy the RTO constraint.

Step-by-Step Solution

1
Identify the latency and replication requirements.
The game requires active read and write operations with sub-second latency in both North America and Europe.
This indicates a need for a multi-region active-active database configuration, as single-region databases would introduce significant network latency for cross-region writes.
2
Evaluate the Recovery Time Objective (RTO) and Recovery Point Objective (RPO) constraints.
RTO must be less than 1 minute, and RPO must be near 0.
This requires automated failover capabilities and continuous, sub-second data replication across regions.
3
Match the requirements against AWS database services.
Amazon DynamoDB global tables provide fully managed, active-active multi-region replication with sub-second replication latency, meeting all performance, HA, and RTO/RPO requirements.
Relational databases like RDS and Aurora do not natively support active-active writes in multiple regions without write-forwarding latency or manual failover overhead.

Key Concept

Amazon DynamoDB Global Tables provide fully managed, active-active multi-region replication for high availability and low-latency local reads and writes.
Estimated Time:1m 30s
Rate this question

Topics

Resilient Database Configurations and High Availability

More questions from this topic