Examkin

Soru

Zorluk: OrtaResilient Database Configurations and High Availability

A software-as-a-service (SaaS) company hosts its customer relationship management (CRM) application on AWS, utilizing an Amazon RDS for PostgreSQL DB instance for the transactional database. The company needs to design a database architecture that ensures high availability within the region to survive an Availability Zone (AZ) outage with a Recovery Time Objective (RTO) of less than 2 minutes and a Recovery Point Objective (RPO) of 0. Additionally, the database must be able to scale to handle a high volume of read-only reporting queries during business hours without impacting write performance. Which database configuration meets these requirements?

  1. Configure the RDS DB instance as a Multi-AZ deployment, and create one or more RDS Read Replicas in different Availability Zones to handle the read-only reporting traffic.Cevap
  2. B
    Configure the RDS DB instance as a single-AZ deployment, create multiple Read Replicas in different Availability Zones, and configure the application to use the Read Replicas as automatic failover targets.
  3. C
    Configure the RDS DB instance as a Multi-AZ deployment, and use Amazon Route 53 latency routing to distribute read traffic between the active primary DB instance and the passive standby DB instance.
  4. D
    Configure the RDS DB instance as a Multi-AZ deployment, and implement a cross-region Pilot Light configuration to serve the reporting queries from a read-only standby instance in a secondary region.

Cevap

Configure the RDS DB instance as a Multi-AZ deployment, and create one or more RDS Read Replicas in different Availability Zones to handle the read-only reporting traffic.
The correct configuration uses RDS Multi-AZ to achieve high availability with synchronous replication to a standby instance in another AZ, enabling automatic failover with zero data loss (RPO of 0) and low downtime (RTO of less than 2 minutes). Creating Read Replicas offloads read traffic to separate endpoints, scaling read performance without affecting the primary writer instance.

Adım Adım Çözüm

1
Evaluate the high availability (HA) requirements.
To meet an RTO of less than 2 minutes and an RPO of 0 (no data loss) during an AZ outage, a Multi-AZ deployment is required because it uses synchronous replication to a standby instance in another AZ and performs automatic failover.
Single-AZ deployments or asynchronous read replicas cannot guarantee zero data loss or automatic failover within the required RTO.
2
Evaluate the read-scaling requirements.
To scale read-only reporting queries without affecting the primary writer instance, RDS Read Replicas must be deployed.
Read replicas utilize asynchronous replication to process read-only queries, freeing up resources on the primary DB instance.
3
Combine the HA and read-scaling configurations.
The final architecture requires a Multi-AZ deployment for HA and automatic failover, coupled with Read Replicas to offload read-only queries.
This combination successfully satisfies both resilience and performance scaling constraints.

Anahtar Kavram

Amazon RDS Multi-AZ deployments provide high availability and automatic failover, while Read Replicas provide horizontal scaling for read-heavy workloads.
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Resilient Database Configurations and High Availability

Bu konudan daha fazla soru