Examkin

Soru

Zorluk: KolayHigh-Performing Database Solutions

A company runs a production database on an Amazon RDS for PostgreSQL DB instance. The application experiences a sudden increase in read traffic, causing high database CPU utilization and increased query latency. The application requires sub-millisecond latency for frequently accessed data, and the overall read load on the primary database must be reduced. Which two actions should a solutions architect take to meet these requirements? (Select TWO.)

  1. Deploy an Amazon ElastiCache cluster to cache frequently accessed query results.Cevap
  2. Create Amazon RDS read replicas to offload read traffic from the primary DB instance.Cevap
  3. C
    Enable Amazon RDS Multi-AZ deployment and configure the application to direct read queries to the standby DB instance.
  4. D
    Migrate the database to Amazon DynamoDB and define the partition key using a monotonically increasing timestamp.

Cevap

Deploying an Amazon ElastiCache cluster to cache queries and creating Amazon RDS read replicas to offload read traffic.
To achieve sub-millisecond read latency, caching is required. Deploying an in-memory cache such as Amazon ElastiCache in front of the database stores the results of common queries, serving them extremely quickly. To offload the remaining read traffic from the primary database, Amazon RDS read replicas are used to distribute the read workload horizontally across one or more replica nodes.

Adım Adım Çözüm

1
Analyze the performance requirements: the workload needs to handle high read volume and achieve sub-millisecond latency for frequently accessed data.
Caching is required for sub-millisecond latency, and read scaling is needed for the remaining database read traffic.
Standard relational databases cannot guarantee sub-millisecond latencies under high load, but an in-memory cache can.
2
Identify the caching layer options.
Amazon ElastiCache is the standard in-memory caching service for RDS that provides sub-millisecond retrieval speeds.
Caching frequently accessed data directly offloads the database and provides the required low latency.
3
Identify the database scaling options for the remaining read traffic.
Amazon RDS read replicas scale read throughput horizontally.
Read replicas allow the application to route read-only queries away from the primary database instance.

Anahtar Kavram

Scaling relational database read performance using in-memory caching and read replicas.
Bu soruyu puanla

Konular

High-Performing Database Solutions

Bu konudan daha fazla soru