Answer-first summary for fast verification
Answer: Use an Amazon RDS Multi-AZ DB cluster deployment. Point the read workload to the reader endpoint.
## Explanation **Correct Answer: D** **Why Option D is correct:** 1. **RDS Multi-AZ DB cluster deployment** provides high availability with automatic failover in less than 40 seconds (typically 35 seconds). 2. **Reader endpoint** automatically distributes read traffic across all read replicas in the cluster, efficiently offloading reads from the primary instance. 3. **Cost optimization**: The Multi-AZ DB cluster uses a cluster volume that spans multiple Availability Zones, providing better performance and cost efficiency compared to traditional Multi-AZ deployments. 4. **Simplified management**: The question specifically mentions using "Amazon RDS for PostgreSQL DB cluster" to simplify administrative tasks. **Why other options are incorrect:** **Option A**: While Multi-AZ DB instance provides high availability, creating a separate read replica adds additional cost and complexity. The failover time might not be consistently under 40 seconds. **Option B**: Creating two read replicas in a Multi-AZ DB cluster deployment would be more expensive than necessary and doesn't leverage the built-in reader endpoint functionality. **Option C**: Secondary instances in a Multi-AZ pair are synchronous standby replicas primarily for failover, not for read scaling. They cannot be used for read workloads as they are not accessible for read operations. **Key AWS Concepts:** - **RDS Multi-AZ DB cluster**: Provides high availability with automatic failover (< 40 seconds) and uses a cluster volume across multiple AZs. - **Reader endpoint**: Automatically load balances read traffic across all read replicas in the cluster. - **Cost optimization**: Multi-AZ DB cluster is more cost-effective than traditional Multi-AZ with separate read replicas. - **Read scaling**: Offloading read traffic improves performance and reduces load on the primary instance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company wants to use an Amazon RDS for PostgreSQL DB cluster to simplify time-consuming database administrative tasks for production database workloads. The company wants to ensure that its database is highly available and will provide automatic failover support in most scenarios in less than 40 seconds. The company wants to offload reads off of the primary instance and keep costs as low as possible.
Which solution will meet these requirements?
A
Use an Amazon RDS Multi-AZ DB instance deployment. Create one read replica and point the read workload to the read replica.
B
Use an Amazon RDS Multi-AZ DB cluster deployment. Create two read replicas and point the read workload to the read replicas.
C
Use an Amazon RDS Multi-AZ DB instance deployment. Point the read workload to the secondary instances in the Multi-AZ pair.
D
Use an Amazon RDS Multi-AZ DB cluster deployment. Point the read workload to the reader endpoint.