Soru

Zorluk: OrtaHigh-Performing Database Solutions

A Solutions Architect is designing the database architecture for a global corporate travel booking application. The application needs to support high-throughput booking transactions in the primary AWS Region and provide employees worldwide with access to travel history queries with latency under 100 milliseconds. Which of the following database configurations should the Solutions Architect select to meet these performance requirements? (Select TWO.)

  1. Migrate the database to Amazon Aurora MySQL and configure an Aurora Global Database with read replicas in the secondary Regions to serve local reads.Cevap
  2. Deploy an Amazon ElastiCache for Redis cluster in each Region to cache frequently read order history data and minimize read latency.Cevap
  3. C
    Configure Amazon RDS for MySQL with cross-Region read replicas, and set up the application to promote the replicas to primary instances during peak write periods to distribute write operations.
  4. D
    Migrate the database to an Amazon DynamoDB table using the transaction timestamp as the partition key to ensure sequential sorting and high write performance.
  5. E
    Move the order history data to an Amazon DynamoDB table configured in Provisioned Capacity Mode with static read and write capacity units to handle highly unpredictable, spiky traffic.

Cevap

Migrate the database to Amazon Aurora MySQL with an Aurora Global Database configuration and deploy an Amazon ElastiCache for Redis cluster in each Region to cache queries.
Migrating the application database to Amazon Aurora MySQL and using Aurora Global Database enables local read replicas in secondary Regions, which reduces read latency significantly for global users. In addition, deploying Amazon ElastiCache for Redis in each Region caches queries close to the application servers, satisfying the sub-100 millisecond response time requirement.

Adım Adım Çözüm

1
Analyze read and write requirements.
Write transactions occur in a primary Region, while read queries must be served globally under 100 milliseconds.
This establishes that the solution requires a high-performance write capability in the primary Region and low-latency read replica or caching mechanisms in remote Regions.
2
Evaluate global database technologies.
Amazon Aurora Global Database provides replication to secondary Regions with typical latencies of less than 1 second, enabling fast local reads.
Serving reads locally from secondary Regions is essential to achieve sub-100 millisecond read performance globally.
3
Evaluate in-memory caching solutions.
Amazon ElastiCache for Redis can store travel history queries locally in each Region for sub-millisecond retrieval.
Caching frequently accessed static data reduces database load and guarantees consistent ultra-low latency.

Anahtar Kavram

Scaling global reads with minimal latency requires a combination of local in-memory caching (Amazon ElastiCache) and fast replication to remote database endpoints (Amazon Aurora Global Database). Schema designs must avoid monotonically increasing keys (like timestamps) to prevent partition hotspots.
Bu soruyu puanla