Exam AWS Certified SysOps Administrator - Associate topic 1 question 257 discussion

Exam question from Amazon's AWS Certified SysOps Administrator - Associate

Question #: 257
Topic #: 1

[All AWS Certified SysOps Administrator - Associate Questions]

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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️

by anderri at Feb. 16, 2023, 12:58 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

jipark

10 months, 1 week ago

Selected Answer: D

why D. RDS proxy have no downtime. why not C. read replica cannot cover write transaction.

upvoted 3 times

...

Christina666

11 months, 1 week ago

Selected Answer: D

Option C (Create a read replica in another AWS Region. Promote the read replica in case of failure) provides additional data redundancy, but it introduces cross-region replication and may not be the most efficient way to reduce the failover time. Cross-region replication involves data transfer between regions, which can add latency and may not be as fast as using an RDS proxy within the same region.

upvoted 2 times

Christina666

11 months, 1 week ago

Option D (Create an RDS proxy. Point the application to the proxy endpoint) is the correct solution for decreasing failover time. An RDS proxy acts as an intermediate layer between the application and the RDS database. It allows for fast and automated failover during Multi-AZ database failover scenarios. When a failover occurs, the RDS proxy automatically connects the application to the new primary instance, reducing the time it takes for the application to be back online. By using an RDS proxy, the failover time is reduced because the proxy maintains connections to both the primary and standby database instances. It also automatically routes the connections to the healthy instance, making the failover process seamless for the application.

upvoted 1 times

...

csG13

1 year, 3 months ago

Selected Answer: D

It’s D - RDS proxy can improve db failover by 32% for MySQL, PostgreSQL and 79% for Aurora service. https://aws.amazon.com/blogs/database/improving-application-availability-with-amazon-rds-proxy/

upvoted 3 times

...

anderri

1 year, 4 months ago

Selected Answer: D

With RDS Proxy, failover times for Aurora and RDS databases are reduced by up to 66% | https://aws.amazon.com/rds/proxy/

upvoted 4 times

...