Examkin

Soru

Zorluk: ZorHigh-Performing Database Solutions

A ride-hailing company is experiencing performance issues with its backend application. The application requires sub-millisecond latencies when querying and updating active driver coordinates. Additionally, daily analytical reports running against the transaction log on an Amazon RDS for PostgreSQL DB instance are causing high CPU utilization and latency for online transactions. Which two database architectural decisions should the Solutions Architect implement to meet these performance requirements? (Select TWO.)

  1. Deploy Amazon ElastiCache for Redis to store and retrieve the real-time driver coordinates.Cevap
  2. Create an Amazon RDS Read Replica to run the daily analytical reports instead of running them on the primary DB instance.Cevap
  3. C
    Configure the RDS Read Replicas as the primary disaster recovery failover targets to handle application write traffic during database failures.
  4. D
    Migrate the coordinates data to an Amazon DynamoDB table using a partition key based on the booking timestamp.
  5. E
    Migrate the coordinate data to a DynamoDB table configured in Provisioned Capacity Mode to handle the highly unpredictable, spiky ride request volume.

Cevap

Deploy Amazon ElastiCache for Redis to store and retrieve real-time driver coordinates, and create an Amazon RDS Read Replica to run daily analytical reports.
Deploying Amazon ElastiCache for Redis provides sub-millisecond latencies required for driver coordinates, and creating an Amazon RDS Read Replica offloads analytical queries to prevent resource contention on the primary database.

Adım Adım Çözüm

1
Analyze the latencies for coordinates queries.
The requirement is sub-millisecond latency for driver coordinates.
Relational databases cannot guarantee sub-millisecond latencies, whereas an in-memory cache like Amazon ElastiCache for Redis handles high-frequency coordinate queries within microseconds.
2
Address the analytical query performance bottleneck.
Create an RDS Read Replica.
Analytical reports generate complex read queries. Running them on a dedicated Read Replica prevents resource contention on the primary DB instance, which performs online transactions.
3
Evaluate the partitioning strategy for coordinates.
Avoid monotonically increasing keys (timestamps) for DynamoDB.
If DynamoDB were used, a timestamp key would direct all traffic to a single partition, violating the best practice of distributing traffic uniformly across partition keys.

Anahtar Kavram

Selecting and configuring high-performing database options by offloading read workloads with replicas and caching real-time data using in-memory databases.
Bu soruyu puanla

Konular

High-Performing Database Solutions

Bu konudan daha fazla soru