AWS Certified Sysops Administrator Associate · Free Practice Question Medium
Question 59
A SysOps administrator manages a resilient system architecture. The infrastructure includes Amazon EC2 instances and an Amazon RDS Multi-AZ database setup. The EC2 instances are behind an Application Load Balancer in an Auto Scaling group.
The company recently performed a system failover test. The SysOps administrator is tasked with reducing the failover time of the RDS database.
Which approach would meet these criteria?
-
A
Configure the RDS Multi-AZ deployment to run across AWS Regions.
-
B
Add more CPU and memory to the RDS database instance.
-
C
Create an RDS Proxy and direct the application towards the proxy endpoint.
-
D
Configure the RDS DB to operate within a single Availability Zone.
Reveal correct answer
Correct answer: C
Explanation
Using RDS Proxy can help manage connections and improve failover times. When a failover happens, RDS Proxy automatically connects to a new database instance while preserving existing database connections. This reduces the amount of time your application might be unavailable during certain types of failover.
CORRECT: "Create an RDS Proxy and direct the application towards the proxy endpoint" is the correct answer (as explained above.)
INCORRECT: "Add more CPU and memory to the RDS database instance" is incorrect.
This wouldn't necessarily decrease failover time. Failover time is usually related to how quickly a standby database can take over in case of a failure, and increasing computational capacity does not directly impact this.
INCORRECT: "Configure the RDS DB to operate within a single Availability Zone" is incorrect.
Reducing the infrastructure to a single Availability Zone would increase the risk of downtime, as there would be no readily available backup in the case of an AZ failure.
INCORRECT: "Configure the RDS Multi-AZ deployment to run across AWS Regions" is incorrect.
You cannot configure multi-AZ RDS deployments to run across AWS Regions.
References:
https://aws.amazon.com/rds/proxy/
Save time with our AWS cheat sheets:
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
