AWS Certified Solutions Architect – Associate (SAA-C03) — Question 928

A global ecommerce company runs its critical workloads on AWS. The workloads use an Amazon RDS for PostgreSQL DB instance that is configured for a Multi-AZ deployment.

Customers have reported application timeouts when the company undergoes database failovers. The company needs a resilient solution to reduce failover time.

Which solution will meet these requirements?

Answer options

• A. Create an Amazon RDS Proxy. Assign the proxy to the DB instance.
• B. Create a read replica for the DB instance. Move the read traffic to the read replica.
• C. Enable Performance Insights. Monitor the CPU load to identify the timeouts.
• D. Take regular automatic snapshots. Copy the automatic snapshots to multiple AWS Regions.

Correct answer: A

Explanation

Amazon RDS Proxy reduces database failover times by preserving client connections and automatically routing traffic to the new primary DB instance without requiring application-side connection retries. Creating a read replica helps with read scaling but does not speed up the primary instance's failover process. Performance Insights and copying snapshots are useful for monitoring and disaster recovery respectively, but neither addresses or reduces failover transition times.