A company wants to use an Amazon RDS for PostgreSQL DB cluster to reduce administrative overhead for production workloads. The database must be highly available with automatic failover in most scenarios under 40 seconds. The company also wants to offload reads from the primary and keep costs low. Which solution meets these requirements?

The correct solution is to use an Amazon RDS Multi-AZ DB cluster deployment and point the read workload to the reader endpoint. An RDS Multi-AZ DB cluster provides high availability with automatic failover typically under 35 seconds, meeting the requirement for failover under 40 seconds. It consists of one writer instance and two readable standby instances in different Availability Zones, which are kept up-to-date using synchronous replication. The reader endpoint automatically distributes read traffic across the readable standby instances, effectively offloading reads from the primary and keeping