Question

Difficulty: EasyResilient Database Configurations and High Availability

A company is deploying a global gaming application that requires a multi-region, active-active database configuration. The database must allow users in both North America and Europe to perform local read and write operations with sub-millisecond latency. The data must be replicated bi-directionally across regions with a Recovery Point Objective (RPO) of less than 1 second. Which two database configuration steps should the solutions architect perform to meet these requirements?

  1. Create an Amazon DynamoDB table and enable DynamoDB Streams with the "New and old images" view type.Answer
  2. Add the replica region to the DynamoDB table to automatically establish a DynamoDB global table.Answer
  3. C
    Deploy an Amazon RDS PostgreSQL DB instance in Multi-AZ mode and configure cross-region read replicas to accept local write operations in both regions.
  4. D
    Configure Route 53 latency-based routing to direct write requests to the nearest database endpoint and automatically synchronize writes across regions.
  5. E
    Deploy a warm standby database replica in the secondary region and set up a pilot light replication model to handle active-active traffic.

Answer

To meet the requirements of active-active writes, low latency, and sub-second replication across multiple regions, you must configure Amazon DynamoDB global tables. This is achieved by creating a DynamoDB table, enabling DynamoDB Streams with the new and old images view type, and then adding the target replica region to the table configuration.
Establishing a global, active-active database configuration with sub-millisecond latency requires Amazon DynamoDB global tables. To configure global tables, a solutions architect must enable DynamoDB Streams with the new and old images view type on the source table and then add the replica regions. This configures managed bi-directional replication, allowing local reads and writes in all replica regions.

Step-by-Step Solution

1
Identify the active-active multi-region database requirement.
Amazon DynamoDB global tables is identified as the appropriate service to support active-active writes and reads in multiple regions with sub-millisecond latencies.
Relational databases like RDS do not support multi-region active-active write configurations natively, whereas DynamoDB global tables provide fully managed, multi-region replication with local read/write performance.
2
Configure the prerequisites for DynamoDB global tables.
Enable DynamoDB Streams on the primary table with the view type set to new and old images.
DynamoDB global tables rely on DynamoDB Streams to track and propagate changes across region replicas.
3
Add replica regions to the table configuration.
Add the desired AWS region as a replica in the table's global tables settings.
This establishes the bi-directional replication between the selected regions to complete the global tables setup.

Key Concept

Amazon DynamoDB Global Tables
Rate this question