ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified SysOps Administrator - Associate All Questions

View all questions & answers for the AWS Certified SysOps Administrator - Associate exam
Go to Exam

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jipark
8 months, 3 weeks ago
Selected Answer: D
why D. RDS proxy have no downtime. why not C. read replica cannot cover write transaction.
upvoted 3 times
...
Christina666
9 months, 2 weeks 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
9 months, 2 weeks 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, 2 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, 2 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago