Examkin

Question

Difficulty: MediumResilient Database Configurations and High Availability

An enterprise retail company wants to deploy a multi-region, active-active database configuration for its online shopping cart application. The database needs to support write operations in both the us-east-1 and us-west-2 Regions with sub-second replication latency. The solution must achieve a Recovery Point Objective (RPO) of under 1 second and a Recovery Time Objective (RTO) of near-zero in the event of a regional outage. The database must automatically handle replication and conflict resolution based on a last-writer-wins rule. Which two actions should a solutions architect take to configure the database to meet these resilience requirements? (Select two.)

  1. Enable Amazon DynamoDB Streams on the primary table in us-east-1 and set the stream view type to NEW_AND_OLD_IMAGES.Answer
  2. Add a replica of the table in us-west-2 to the DynamoDB table configuration to establish a global table.Answer
  3. C
    Set up Amazon Route 53 Latency routing with active-passive failover checks to route database write queries, relying on DNS routing to manage write replication.
  4. D
    Deploy an Amazon RDS for PostgreSQL database in us-east-1 and configure a cross-region read replica in us-west-2, promoting the replica manually during a regional failover.
  5. E
    Configure an Amazon Aurora PostgreSQL Global Database and write a custom AWS Lambda script to execute a manual database failover using a pilot light disaster recovery strategy.

Answer

The correct options are to enable Amazon DynamoDB Streams with the stream view type set to NEW_AND_OLD_IMAGES, and to add a replica of the table in the us-west-2 Region to establish a global table.
To support active-active writes in both us-east-1 and us-west-2 with an RPO of under 1 second and automatic conflict resolution, Amazon DynamoDB Global Tables is the ideal solution. Configuring a global table requires enabling DynamoDB Streams on the source table with the stream view type set to NEW_AND_OLD_IMAGES, and then adding the replica region to create the multi-region configuration.

Step-by-Step Solution

1
Enable DynamoDB Streams with NEW_AND_OLD_IMAGES on the existing DynamoDB table in the primary region.
Creates a stream that captures all modifications (insert, update, delete) to the table data, which DynamoDB uses to replicate changes.
DynamoDB Streams is a mandatory prerequisite for setting up DynamoDB Global Tables.
2
Add the target replica region (us-west-2) to the DynamoDB table configuration.
Creates an identical table in the secondary region and enables bi-directional active-active replication between the regions.
This establishes a DynamoDB Global Table, which natively replicates updates with sub-second latency and automatically handles conflict resolution.

Key Concept

Amazon DynamoDB Global Tables provides a fully managed, multi-region, active-active database replication solution. To configure it, you must enable DynamoDB Streams with the NEW_AND_OLD_IMAGES view type on the source table and add replica regions to the table configuration.
Rate this question

Topics

Resilient Database Configurations and High Availability

More questions from this topic