AWS Certified Solutions Architect – Associate (SAA-C03) — Question 412
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?
Answer options
- 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 duster 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.
Correct answer: D
Explanation
An Amazon RDS Multi-AZ DB cluster deployment provides high availability with automatic failover that typically completes in under 35 seconds, and it includes a built-in reader endpoint to offload read traffic to the reader instances without additional costs. In contrast, an Amazon RDS Multi-AZ DB instance deployment has a slower failover time of 60 to 120 seconds and does not support reading from the standby instance. Option B is incorrect because a Multi-AZ DB cluster already contains reader instances, making additional read replicas an unnecessary extra expense.