AWS Certified SysOps Administrator – Associate — Question 166

A company's SysOps administrator maintains a highly available environment. The environment includes Amazon EC2 instances and an Amazon RDS Multi-AZ database. The EC2 instances are in an Auto Scaling group behind an Application Load Balancer.

Recently, the company conducted a failover test. The SysOps administrator needs to decrease the failover time of the RDS database by at least 10%.

Which solution will meet this requirement?

Answer options

• A. Increase the RDS instance size.
• B. Modify the RDS cluster to run in a single Availability Zone.
• C. Create a read replica in another AWS Region. Promote the read replica in case of failure.
• D. Create an RDS proxy. Point the application to the proxy endpoint.

Correct answer: D

Explanation

Creating an RDS proxy helps reduce failover time by managing connection pooling and enhancing the application's ability to connect to the database efficiently. Increasing the RDS instance size (A) does not directly impact failover speed, modifying to a single Availability Zone (B) compromises high availability, and creating a read replica in another region (C) introduces latency rather than reducing failover time.