Examkin

Question

Difficulty: EasyDatabase and Storage Strategy

An organization plans to host a lightweight inventory management service classified as an Online Transaction Processing (OLTP) workload. The service uses a relational database and requires low read latency as its key performance indicator during sudden, unpredictable query spikes, while keeping database costs low during idle periods.

Which database and storage strategy meets these requirements with the minimum operational overhead?

  1. A
    Use Amazon RDS for MySQL in a Multi-AZ configuration and direct read traffic to the standby DB instance.
  2. Use Amazon Aurora MySQL and enable Aurora Auto Scaling to dynamically adjust the number of Aurora Replicas based on average CPU utilization.Answer
  3. C
    Use Amazon RDS for MySQL and create a cross-Region Read Replica using AWS-managed KMS keys for cross-account log replication.
  4. D
    Use Amazon Aurora MySQL with a Pilot Light disaster recovery strategy to scale out read nodes during peak traffic hours.

Answer

Use Amazon Aurora MySQL and enable Aurora Auto Scaling to dynamically adjust the number of Aurora Replicas based on average CPU utilization.
The correct strategy uses Amazon Aurora MySQL with Aurora Auto Scaling. Aurora Replicas share the same storage volume as the primary instance, allowing them to scale out quickly with minimal replication lag. Aurora Auto Scaling automates the addition and removal of these replicas based on load (such as CPU utilization), minimizing operational overhead while keeping costs optimized during idle periods.

Step-by-Step Solution

1
Analyze the workload requirements: relational database for an OLTP workload, low read latency during unpredictable spikes, cost minimization during idle periods, and minimal operational overhead.
Identify that the solution must support automatic scaling of read capacity.
Sudden, unpredictable traffic spikes cannot be efficiently handled with manual intervention or scheduled scaling.
2
Evaluate the read-scaling capabilities of AWS database services.
Amazon Aurora Replicas support auto-scaling, whereas Amazon RDS Multi-AZ standby instances are passive and cannot serve read traffic.
This rules out standard RDS Multi-AZ configurations for scaling read queries.
3
Select the strategy that offers automatic scale-in/scale-out of read replicas with minimal latency and replication overhead.
Amazon Aurora MySQL with Aurora Auto Scaling is selected.
Aurora Replicas use a shared storage volume, reducing replication lag compared to standard RDS read replicas, and Aurora Auto Scaling handles the provisioning automatically.

Key Concept

Relational read capacity scaling using Amazon Aurora Replicas and Aurora Auto Scaling.
Estimated Time:1m 0s
Rate this question

Topics

Database and Storage Strategy

More questions from this topic