Examkin

Question

Difficulty: EasyDatabase and Storage Strategy

A solutions architect is designing the database strategy for a new Online Transaction Processing (OLTP) workload. The application requires a relational database, automatic failover with a Recovery Time Objective (RTO) of less than 120 seconds, and horizontal scaling of read throughput to handle traffic spikes. Which of the following database configurations meet these requirements? (Select TWO.)

  1. Amazon Aurora MySQL with Aurora Replicas deployed across multiple Availability ZonesAnswer
  2. Amazon RDS for MySQL in a Multi-AZ deployment with one or more Read Replicas deployed in different Availability ZonesAnswer
  3. C
    Amazon RDS for MySQL in a Multi-AZ deployment, using the standby replica to serve read traffic during peak periods
  4. D
    Amazon RDS for MySQL in a single-instance configuration, relying on automated daily snapshots to restore the database to a secondary Availability Zone during a failure
  5. E
    Amazon Aurora MySQL with cross-account Aurora Replicas encrypted using the default AWS-managed KMS key (aws/rds) to share data across accounts

Answer

The correct configurations are Amazon Aurora MySQL with Aurora Replicas deployed across multiple Availability Zones, and Amazon RDS for MySQL in a Multi-AZ deployment with one or more Read Replicas deployed in different Availability Zones.
Amazon Aurora MySQL native routing allows Aurora Replicas to serve read traffic while acting as hot standbys for automatic failover within 30 seconds. Amazon RDS for MySQL Multi-AZ deployments provide synchronous replication to a standby instance for automatic failover (RTO < 120 seconds), while separate Read Replicas are used to scale read traffic horizontally.

Step-by-Step Solution

1
Analyze the requirements for OLTP workload, relational engine, automatic failover with RTO < 120 seconds, and read scaling.
Identify that the solution must provide both high availability (active-passive failover) and read scalability (active-active read path).
This filters out single-instance setups and configurations that cannot scale reads.
2
Evaluate Amazon Aurora replication capabilities.
Confirm Aurora Replicas support both auto-failover (RTO < 30 seconds) and read scaling.
Aurora native architecture supports up to 15 Aurora Replicas sharing the same storage layer for read scaling and failover.
3
Evaluate standard Amazon RDS for MySQL replication capabilities.
Confirm standard RDS Multi-AZ provides synchronous replication and automatic failover (RTO 60-120 seconds), while separate Read Replicas provide horizontal read scaling.
Standard RDS standby instances cannot serve traffic, necessitating separate Read Replicas for scaling reads.

Key Concept

Distinguishing read scaling mechanisms and high availability architectures in Amazon RDS and Amazon Aurora.
Rate this question

Topics

Database and Storage Strategy

More questions from this topic