Examkin

Question

Difficulty: EasyHigh-Performing Database Solutions

A solutions architect is designing a web application that uses an Amazon RDS for PostgreSQL database. The application is experiencing high read latency due to a large volume of read requests. Which solution will most effectively reduce read latency for frequently accessed data to sub-milliseconds?

  1. Deploy Amazon ElastiCache in front of the Amazon RDS database to cache frequently accessed read queries.Answer
  2. B
    Configure Amazon RDS Read Replicas and configure the application to promote a read replica to the primary database to improve read latency.
  3. C
    Migrate the database to Amazon DynamoDB and use sequential timestamps as partition keys to distribute the write and read load.
  4. D
    Migrate the database to Amazon DynamoDB configured in Provisioned Capacity mode to handle highly unpredictable, spiky read workloads.

Answer

Deploy Amazon ElastiCache in front of the Amazon RDS database to cache frequently accessed read queries.
Deploying Amazon ElastiCache in front of the Amazon RDS database is the standard high-performance architecture pattern to serve read requests from memory, reducing query response times to sub-milliseconds.

Step-by-Step Solution

1
Identify the latency and access requirements from the scenario.
The application requires sub-millisecond read latency for frequently accessed database queries.
Recognizing that the target is sub-millisecond reads narrows down the choice to in-memory caching solutions.
2
Evaluate the caching capabilities of Amazon ElastiCache vs other database configurations.
Amazon ElastiCache caches RDS query results in memory, offering sub-millisecond retrieval speeds.
Standard RDS configurations (including read replicas) cannot guarantee sub-millisecond latencies for arbitrary query patterns.

Key Concept

Using an in-memory cache like Amazon ElastiCache to offload read queries from a relational database and achieve sub-millisecond latencies.
Estimated Time:1m 0s
Rate this question

Topics

High-Performing Database Solutions

More questions from this topic