Q23 — AWS SAA-C03 Ch.14

Question 23 of 100 | ← Chapter 14

Q1023. 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?

• 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. Create an Amazon RDS Proxy. Assign the proxy to the DB instance.

Explanation

To reduce failover time and improve resilience during database failovers for an Amazon RDS for PostgreSQL DB instance configured for Multi-AZ deployment, the best solution is:A. Create an Amazon RDS Proxy. Assign the proxy to the DB instance.Explanation:\1. Amazon RDS Proxy: - RDS Proxy sits between your application and the RDS database, managing database connections more efficiently. It can help reduce the impact of failovers by pooling and managing connections, allowing your application to quickly reconnect to the standby database during failover events.\2. Connection Management: - During a failover, the application typically experiences a brief period of downtime while it reconnects to the new primary instance. RDS Proxy can reduce this reconnection time, making the application more resilient to database failovers and minimizing timeouts experienced by users.Evaluation of Other Options:B. Create a read replica for the DB instance: - While read replicas can offload read traffic and improve performance, they do not directly address failover times for write operations. During a failover, the application still needs to handle reconnections to the new primary instance.C. Enable Performance Insights: - Performance Insights can help diagnose issues related to performance and timeouts, but it does not actively reduce failover time. It is more of a monitoring tool rather than a solution to the failover problem.D. Take regular automatic snapshots: - While taking snapshots provides data protection, it does not improve failover times. Automatic snapshots are used for backup and recovery but do not address the issue of minimizing downtime during a failover.Conclusion:Option A is the most effective solution for improving resilience and reducing failover time in a Multi-AZ RDS for PostgreSQL deployment, ensuring a smoother experience for users during database failovers.