Examkin

Question

Difficulty: MediumHigh-Performing Database Solutions

A gaming company is launching a global multiplayer game and needs to design a database architecture for player profiles and leaderboards. The database must support high-throughput writes with single-digit millisecond latency for players distributed across North America, Europe, and Asia. Additionally, player profile page lookups must achieve microsecond read latency to prevent page load delays. Which combination of database configurations will meet these performance requirements? (Select TWO.)

  1. Deploy Amazon DynamoDB global tables to replicate data with single-digit millisecond latency across multiple AWS Regions.Answer
  2. Enable Amazon DynamoDB Accelerator (DAX) to provide microsecond read latency for player profile lookups.Answer
  3. C
    Implement Amazon Aurora Global Database and route write operations directly to local read replicas to improve write performance.
  4. D
    Design the DynamoDB table with a partition key containing monotonically increasing timestamps to ensure sequential sorting.
  5. E
    Provision Amazon ElastiCache for Memcached in a Multi-AZ configuration to act as the primary database write target in each region.

Answer

Deploying Amazon DynamoDB global tables and enabling Amazon DynamoDB Accelerator (DAX).
DynamoDB global tables provide a fully managed multi-region database solution that replicates data across AWS Regions, allowing local write and read access with single-digit millisecond latency. DynamoDB Accelerator (DAX) adds a caching layer in front of the tables, reducing the latency of read lookups from milliseconds to microseconds for read-intensive workloads such as player profiles.

Step-by-Step Solution

1
Analyze the workload requirements: global replication with low-latency (single-digit millisecond) writes and read-heavy profile lookups requiring microsecond latency.
Identified that DynamoDB global tables fit the multi-region write requirement, and an in-memory cache is needed for microsecond reads.
DynamoDB global tables support multi-region write replication, and DAX delivers the required microsecond read performance for DynamoDB tables.
2
Evaluate the caching options and reject configurations that process writes to read-only endpoints or cache instances as primary databases.
Eliminated Aurora read replicas for direct writes and Memcached as a primary database write target.
Read replicas cannot handle write transactions, and caching solutions do not provide persistent primary database capabilities.
3
Assess the partition key design to prevent partition bottlenecks during high-throughput writes.
Avoided partition key patterns using sequential or monotonically increasing values.
Using sequential keys distributes traffic unevenly, resulting in hot partitions that throttle overall throughput.

Key Concept

Combining multi-region active-active databases with in-memory caching to achieve high write throughput and microsecond read latencies.
Estimated Time:2m 0s
Rate this question

Topics

High-Performing Database Solutions

More questions from this topic