Which combination of steps should the solutions architect take to meet these requirements?

By:
In: SAP-C02
Tagged:
With: 1 Comment
A company is running a critical application that uses an Amazon RDS for MySQL database to store data.The RDS DB instance is deployed in Multi-AZ mode.A recent RDS database failover test caused a 40-second outage to the application.A solutions architect needs to design a solution to reduce the outage time to less than 20 seconds.

Which combination of steps should the solutions architect take to meet these requirements?

(Choose three.)

Use Amazon ElastiCache for Memcached in front of the database

Use Amazon ElastiCache for Redis in front of the database

Use RDS Proxy in front of the database.

Migrate the database to Amazon Aurora MySQL.

Create an Amazon Aurora Replica.

Create an RDS for MySQL read replica

Explanations:

Using Amazon ElastiCache for Memcached helps with caching but does not directly reduce failover time for the RDS database itself.

Similar to option A, ElastiCache for Redis provides caching benefits but does not address the failover time of the underlying RDS database.

RDS Proxy can help manage database connections and improve failover handling, potentially reducing the application downtime during database failovers.

Migrating to Amazon Aurora MySQL can significantly reduce failover times due to its built-in high availability features and faster recovery mechanisms.

Creating an Amazon Aurora Replica can improve read availability and reduce downtime during failovers, enhancing overall application resilience.

An RDS for MySQL read replica can provide read scalability but does not effectively reduce the failover time for the primary database instance.

2025-10-18

1 Comment

  1. Pamela
    Author

    I scheme that the answer is:
    Use RDS Proxy in front of the database.

Leave a Reply

Your email address will not be published. Required fields are marked *

five × 3 =