exam questions

Exam AWS Certified SysOps Administrator - Associate All Questions

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

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

A company has an application that uses an Amazon RDS for MariaDB Multi-AZ database. The application becomes unavailable for several minutes every time the database experiences a failover during a planned maintenance event.

What should a SysOps administrator do to reduce the downtime of the application during failover?

  • A. Create an RDS for MariaDB DB cluster that has multiple writer instances. Configure the application to retry failed queries on another primary node during maintenance events.
  • B. Configure the RDS maintenance window settings to pool connections while a failover is in process.
  • C. Configure an Amazon ElastiCache write-through cache for the database. Configure the application to connect to the cache instead of directly to the database.
  • D. Create an RDS proxy that is associated with the database. Configure the application to connect to the proxy instead of directly to the database.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
tgv
6 months, 1 week ago
Selected Answer: D
When failovers occur, RDS Proxy routes requests directly to the new database instance. This reduces failover times for Aurora and RDS databases by up to 66%. RDS Proxy also supports Multi-AZ with two readable standbys for typically under 35 second failovers, 2x improved write latency, added read capacity, and reduce minor version upgrade downtime to typically under 1 second. https://aws.amazon.com/rds/proxy/
upvoted 2 times
...
andy_sds
6 months, 1 week ago
Selected Answer: D
https://aws.amazon.com/ko/blogs/database/improving-application-availability-with-amazon-rds-proxy/
upvoted 2 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago