Examkin

Question

Difficulty: MediumDatabase and Storage Strategy

A company is designing a new real-time mobile gaming leaderboard and user profile service (NoSQL and key-value caching workload) that must support users across North America and Europe. The key performance indicators include single-digit millisecond latency for both write and read operations globally. The session store and query cache must support data persistence, multi-Availability Zone replication, and sub-key eviction. Additionally, the database tier must support an active-active multi-region deployment to meet a Recovery Time Objective (RTO) of near-zero. Which of the following database and storage configurations should the solutions architect select to meet these requirements? (Select TWO.)

  1. Deploy an Amazon DynamoDB table with global tables enabled in the required regions to achieve active-active replication and single-digit millisecond latency.Answer
  2. Deploy an Amazon ElastiCache for Redis cluster with Multi-AZ and auto-failover enabled to cache frequent queries and provide session storage with data persistence.Answer
  3. C
    Deploy Amazon ElastiCache for Memcached to provide a persistent, replicated session cache with sub-key eviction.
  4. D
    Deploy Amazon RDS for PostgreSQL in a Multi-AZ configuration, and configure the standby instance in the secondary Availability Zone to serve read traffic to offload queries from the primary instance.
  5. E
    Implement a pilot light disaster recovery strategy using database snapshots replicated to the secondary region to achieve the near-zero RTO.

Answer

Deploying an Amazon DynamoDB table with global tables enabled satisfies the active-active multi-region and low-latency database requirements. Deploying an Amazon ElastiCache for Redis cluster with Multi-AZ satisfies the caching and session store requirements including data persistence and sub-key eviction.
Deploying Amazon DynamoDB with global tables enabled provides active-active multi-region replication and single-digit millisecond latency. Deploying Amazon ElastiCache for Redis provides a persistent, replicated cache with sub-key eviction, meeting all key performance indicators.

Step-by-Step Solution

1
Determine the database requirements for active-active global replication.
Amazon DynamoDB with global tables is selected.
DynamoDB Global Tables provide the required active-active multi-region replication and single-digit millisecond read/write latency globally.
2
Determine the caching and session store requirements.
Amazon ElastiCache for Redis is selected.
Redis supports multi-AZ replication, auto-failover, data persistence, and sub-key eviction, unlike Memcached.
3
Eliminate sub-optimal or invalid options.
Options proposing RDS standby reads, Memcached, and pilot light DR are eliminated.
RDS standby instances cannot serve read traffic, Memcached lacks persistence and replication, and pilot light cannot meet a near-zero RTO requirement.

Key Concept

Selecting appropriate database and caching engines to meet multi-region active-active, performance, durability, and availability SLA requirements.
Rate this question

Topics

Database and Storage Strategy

More questions from this topic