SOA-C02 · Question #146
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…
The correct answer is D. Create an RDS proxy that is associated with the database. Configure the application to connect to. 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…
Question
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?
Options
- ACreate an RDS for MariaDB DB cluster that has multiple writer instances. Configure the
- BConfigure the RDS maintenance window settings to pool connections while a failover is in
- CConfigure an Amazon ElastiCache write-through cache for the database. Configure the
- DCreate an RDS proxy that is associated with the database. Configure the application to connect to
How the community answered
(59 responses)- A5% (3)
- B2% (1)
- C10% (6)
- D83% (49)
Explanation
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 https://aws.amazon.com/rds/proxy/
Topics
Community Discussion
No community discussion yet for this question.