Soru

Zorluk: OrtaResilient Database Configurations and High Availability

A company is migrating a financial transaction application to AWS. The application database tier uses Amazon RDS for PostgreSQL. The database must be highly available with automatic failover to support a low recovery time objective (RTO) during an Availability Zone outage. Additionally, the application must offload read-intensive reporting queries from the primary database to prevent performance degradation on write operations.

Which combination of database configurations will meet these requirements? (Select TWO.)

  1. Configure a Multi-AZ DB instance deployment to achieve automatic failover across different Availability Zones.Cevap
  2. Deploy RDS Read Replicas in different Availability Zones to handle the reporting query workload.Cevap
  3. C
    Configure Route 53 latency routing to automatically redirect write traffic to a read replica if the primary database becomes unavailable.
  4. D
    Use a read replica in a different Availability Zone as the primary automated failover target for the database tier.
  5. E
    Utilize a Pilot Light disaster recovery configuration in a second AWS region to achieve automatic database failover within seconds.

Cevap

Deploying a Multi-AZ DB instance configuration to provide high availability and creating RDS Read Replicas to offload reporting workloads is the correct combination of configurations.
To meet the requirements, the solutions architect should deploy a Multi-AZ DB instance configuration and create RDS Read Replicas. A Multi-AZ DB instance deployment provides high availability and automatic failover by synchronously replicating data to a standby instance in a different Availability Zone. Read Replicas allow the database to offload read-intensive reporting workloads by asynchronously replicating data to one or more read-only instances, which prevents read queries from affecting the primary database's write performance.

Adım Adım Çözüm

1
Identify the high availability and failover requirements.
Determine that an Amazon RDS Multi-AZ DB instance deployment is needed to provide synchronous replication and automatic failover in the event of an Availability Zone outage.
Multi-AZ deployments provide built-in high availability and automatic failover for Amazon RDS databases.
2
Identify the read scaling and performance requirements.
Determine that one or more RDS Read Replicas must be created to handle read-heavy reporting queries.
Read replicas use asynchronous replication to offload read traffic from the primary DB instance, protecting write performance.
3
Eliminate options that use incorrect failover mechanisms or disaster recovery strategies.
Reject options proposing read replicas as automatic failover targets, Route 53 latency routing for database failover, or Pilot Light DR for high availability.
Read replicas do not support automatic HA failover, Route 53 latency routing does not manage RDS failover, and Pilot Light configurations have higher RTOs and are meant for disaster recovery, not HA.

Anahtar Kavram

Configuring Amazon RDS for high availability using Multi-AZ deployments and scaling read capacity using Read Replicas.
Bu soruyu puanla