Examkin

Soru

Zorluk: KolayOptimizing Compute and Storage Performance

A financial services firm runs an online transaction processing (OLTP) application using a single Amazon RDS PostgreSQL Multi-AZ DB instance. During peak hours, read-heavy reporting queries cause CPU utilization on the primary instance to reach 100%, degrading write transactions. Which solution should a solutions architect implement to optimize performance and scale read capacity?

  1. Deploy Amazon RDS PostgreSQL Read Replicas and configure the application to route reporting queries to the read replica endpoints.Cevap
  2. B
    Configure the application to route read-only reporting queries directly to the DNS endpoint of the standby DB instance in the secondary Availability Zone.
  3. C
    Request AWS Support to pre-warm the Application Load Balancer to allow it to handle the database read spikes directly.
  4. D
    Enable Auto Scaling on the DB instance configuration to dynamically scale the compute capacity of the standby node to process queries.

Cevap

Deploy Amazon RDS PostgreSQL Read Replicas and configure the application to route reporting queries to the read replica endpoints.
Deploying Amazon RDS PostgreSQL Read Replicas is the correct solution. Read replicas are dedicated active instances that replicate data asynchronously from the primary writer. By routing reporting queries to these endpoints, the CPU load on the primary writer is reduced, resolving the performance degradation.

Adım Adım Çözüm

1
Identify the performance bottleneck on the primary DB instance.
The bottleneck is CPU starvation on the primary DB instance caused by read-heavy reporting queries.
Before recommending a scaling action, we must determine if the workload consists of reads or writes.
2
Evaluate the capabilities of the current RDS Multi-AZ deployment.
The standby DB instance is strictly passive and cannot be used for query routing.
Understanding the limits of Multi-AZ prevents incorrect routing architectures.
3
Select the correct AWS compute/storage optimization feature for RDS read capacity.
Amazon RDS Read Replicas provide horizontal scaling of read operations.
Deploying read replicas offloads query executions from the primary node and restores transaction performance.

Anahtar Kavram

Amazon RDS Read Replicas vs Multi-AZ Standby capabilities
Tahmini Süre:45s
Bu soruyu puanla

Konular

Optimizing Compute and Storage Performance