Examkin

Soru

Zorluk: OrtaDatabase High Availability

A company hosts a high-traffic inventory management system on Amazon RDS for PostgreSQL. During peak operational hours, database performance degrades due to a high volume of read-only queries from a business intelligence tool. Additionally, the company requires a recovery time objective (RTO) of under 10 minutes for any database infrastructure failure. Which configuration should the SysOps Administrator implement to satisfy these requirements?

  1. A
    Create an Amazon RDS Read Replica in a different Availability Zone. Route the main application's write traffic to the primary DB instance, and configure Amazon Route 53 with a failover routing policy to automatically promote and redirect write traffic to the replica if the primary instance fails.
  2. Configure the Amazon RDS DB instance for Multi-AZ deployment, and create a separate RDS Read Replica. Point the main application to the primary DB instance endpoint and the business intelligence tool to the read replica endpoint.Cevap
  3. C
    Configure the Amazon RDS DB instance for Multi-AZ deployment. Direct the main application to the primary DB instance endpoint, and configure the business intelligence tool to connect to the standby DB instance endpoint in the secondary Availability Zone.
  4. D
    Create a second Single-AZ Amazon RDS DB instance in a different Availability Zone. Configure an AWS Lambda function triggered by Amazon CloudWatch alarms to promote this instance and update the application configuration files during a primary database outage.

Cevap

Configure the Amazon RDS DB instance for Multi-AZ deployment, and create a separate RDS Read Replica. Point the main application to the primary DB instance endpoint and the business intelligence tool to the read replica endpoint.
An Amazon RDS Multi-AZ deployment provides automatic synchronous replication and failover to a standby DB instance in a different Availability Zone if the primary instance fails, satisfying the low RTO requirement. To offload read operations from the business intelligence tool, an RDS Read Replica should be deployed, as it provides a dedicated endpoint for read-only queries.

Adım Adım Çözüm

1
Evaluate the database high availability and failover mechanism.
Determine that Amazon RDS Multi-AZ provides automatic, synchronous failover to a standby instance in another Availability Zone, fulfilling the under 10-minute RTO requirement.
Single-AZ instances do not support automatic failover, and custom failover scripts introduce recovery delays.
2
Address the read-scaling requirement for the business intelligence tool.
Identify that a separate RDS Read Replica is required to offload reporting queries.
Standard Multi-AZ standby instances are passive and cannot serve read traffic.
3
Select the unified architecture.
Combine RDS Multi-AZ for failover with an RDS Read Replica for read offloading, routing application writes to the primary DB endpoint and BI queries to the replica endpoint.
This configuration satisfies both RTO and performance requirements with minimal administrative effort.

Anahtar Kavram

Distinguishing between RDS Multi-AZ deployments (used for synchronous high availability and automatic failover) and RDS Read Replicas (used for asynchronous horizontal scaling of read traffic).
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Database High Availability

Bu konudan daha fazla soru