SAA-C03 Q166 · Database

Question

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?

Accepted Answer

**Answer A: Create an Amazon RDS Proxy and assign it to the DB instance.**

Here's why this directly solves the problem:

1. **Root Cause Understanding**: When a Multi-AZ failover occurs, the DNS endpoint for the RDS instance is updated to point to the new primary. However, applications holding existing database connections experience timeouts because those connections are now pointing to the old (failed) instance. Applications must detect the broken connection, resolve DNS again, and establish a new connection — this process causes the timeout customers are experiencing.

2. **How RDS Proxy Solves This**: RDS Proxy sits between the application and the database as a connection pooling layer. During a failover:
   - RDS Proxy maintains the application-facing connections intact
   - It inter

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips