A company runs an application with a database backend on an Amazon RDS for PostgreSQL DB instance. The solutions architect must configure the database to achieve high availability with automatic failover (Recovery Time Objective under 2 minutes) in the event of an Availability Zone outage. Additionally, the application requires read scaling to handle reporting queries during peak hours without impacting the performance of the write database. Which two database configurations should the solutions architect choose to meet these requirements? (Select TWO.)
- Deploy the RDS PostgreSQL DB instance as a Multi-AZ deployment.Answer
- Create one or more RDS Read Replicas to offload reporting queries.Answer
- CConfigure Amazon Route 53 latency-based routing to distribute write traffic between the primary database and read replicas.
- DUse a single-AZ RDS deployment and promote a read replica manually to achieve the required failover time.
- EConfigure cross-Region replication to a warm standby RDS DB instance in another AWS Region for high availability.
Answer
Deploying the Amazon RDS PostgreSQL DB instance in a Multi-AZ configuration to support automatic failover and creating one or more RDS Read Replicas to handle reporting read queries.
To satisfy both requirements, the solutions architect must configure a Multi-AZ deployment to handle high availability and automatic failover in under 2 minutes, and create read replicas to handle the reporting read workload.
Step-by-Step Solution
Key Concept
Configuring Amazon RDS for high availability using Multi-AZ deployments, and scaling read workloads separately using Read Replicas.