Examkin

Soru

Zorluk: OrtaDatabase High Availability

A financial analytics company hosts its transaction-matching engine on a single-instance Amazon RDS for PostgreSQL DB instance. A SysOps Administrator must configure the database tier to achieve automated failover to a standby instance in a different Availability Zone within the same Region in the event of an infrastructure failure. Additionally, the administrator wants to offload read-heavy analytical queries from the primary instance. Which of the following database configurations should the SysOps Administrator implement to meet these requirements with the lowest Recovery Time Objective (RTO)?

  1. Modify the DB instance to a Multi-AZ deployment, and deploy one or more Read Replicas in different Availability Zones to handle the analytical queries.Cevap
  2. B
    Configure a PostgreSQL Read Replica in a different Availability Zone, and configure the application connection string to route write traffic to the replica if the primary instance becomes unavailable.
  3. C
    Enable Cross-Region replication to a standby database instance in another Region, and configure Amazon Route 53 with an active-passive failover routing policy to handle database failover.
  4. D
    Create a CNAME record in Amazon Route 53 pointing to the primary database endpoint, and configure an AWS Lambda function to update the CNAME record to point directly to a read replica during an outage.

Cevap

Modify the DB instance to a Multi-AZ deployment, and deploy one or more Read Replicas in different Availability Zones to handle the analytical queries.
Modifying the database to a Multi-AZ deployment provides automatic, synchronous replication to a standby instance in a different Availability Zone within the same Region. In the event of an infrastructure failure, RDS automatically updates the DNS record to point to the standby instance, ensuring the lowest RTO. Deploying separate read replicas is the correct method to handle read-heavy analytical queries without affecting the primary write instance.

Adım Adım Çözüm

1
Enable Multi-AZ on the RDS for PostgreSQL instance.
Amazon RDS provisions a standby replica in a different Availability Zone and establishes synchronous replication.
This guarantees zero-data-loss failover and automatic DNS endpoint redirection during an outage, minimizing RTO.
2
Create one or more PostgreSQL Read Replicas.
One or more read-only instances are created with asynchronous replication from the primary instance.
This offloads read-heavy analytical workloads from the primary database instance to prevent performance degradation.

Anahtar Kavram

Amazon RDS Multi-AZ deployments provide high availability and automatic failover through synchronous replication to a standby instance, whereas Read Replicas are designed for read scaling and use asynchronous replication.
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Database High Availability

Bu konudan daha fazla soru