Examkin

Soru

Zorluk: OrtaHigh-Performing Database Solutions

A university enrollment portal experiences extremely high read traffic on registration day, causing the database to experience performance degradation. The application's database tier consists of an Amazon Aurora MySQL DB cluster, and the workload primarily consists of queries checking course availability. A solutions architect needs to optimize the database architecture to ensure high performance and scale read capacity dynamically to handle the peak traffic. Which solution meets these requirements with the lowest latency?

  1. Configure Aurora Auto Scaling to dynamically adjust the number of Aurora Replicas in the DB cluster, and configure the application to send search queries to the Aurora reader endpoint.Cevap
  2. B
    Provision cross-region RDS Read Replicas and configure the application to promote a read replica to the primary instance during peak registration hours to handle the read traffic.
  3. C
    Migrate the course availability data to an Amazon DynamoDB table and set the partition key as the course registration timestamp to distribute read and write traffic evenly across partitions.
  4. D
    Migrate the database to Amazon DynamoDB and use Provisioned Capacity Mode with fixed write and read capacity units to absorb the sudden spikes in traffic.

Cevap

Configure Aurora Auto Scaling to dynamically adjust the number of Aurora Replicas in the DB cluster, and configure the application to send search queries to the Aurora reader endpoint.
The correct option is to configure Aurora Auto Scaling with Aurora Replicas and direct read queries to the reader endpoint. Aurora Replicas share the same storage volume as the primary instance, allowing them to serve read requests with very low latency. Aurora Auto Scaling dynamically manages the number of replicas based on CPU utilization or connection count, and the Aurora reader endpoint automatically load-balances connections among these replicas, ensuring high performance under heavy read loads.

Adım Adım Çözüm

1
Analyze the workload requirements
The application is read-heavy (checking course availability) and experiences temporary traffic spikes during registration days.
Identifying that the workload is read-heavy helps narrow down options to those that scale read capacity.
2
Evaluate Amazon Aurora database scaling features
Amazon Aurora supports up to 15 replicas that share the same storage volume. Aurora Auto Scaling can dynamically add or remove replicas based on metric thresholds like CPU utilization.
Dynamic replica scaling directly addresses traffic spikes without manually resizing instances or altering database engines.
3
Select the correct endpoint for distributing read queries
The reader endpoint load-balances read operations across the available Aurora Replicas.
Directing reads to the reader endpoint ensures they are offloaded from the primary instance, maintaining overall system performance.

Anahtar Kavram

Scaling read capacity in Amazon Aurora DB clusters using Aurora Replicas and Auto Scaling
Bu soruyu puanla

Konular

High-Performing Database Solutions

Bu konudan daha fazla soru