Q40 — AWS SAP-C02 Ch.1

Question 40 of 75 | ← Chapter 1

Q115. 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?(Select THREE.)

Correct Answer: C. Use RDS Proxy in front of the database, D. Migrate the database to Amazon Aurora MySQL, E. Create an Amazon Aurora Replica

Explanation

To reduce the outage time to less than 20 seconds during an RDS database failover test, the following steps should be taken: C. Use RDS Proxy in front of the database: RDS Proxy helps to improve failover times by maintaining established connections during failovers, reducing the time required for the application to reconnect to the database after a failover. D. Migrate the database to Amazon Aurora MySQL: Amazon Aurora is a MySQL-compatible managed database service that offers enhanced availability and durability compared to traditional RDS for MySQL. Aurora can provide faster failovers and reduced downtime during failover events. E. Create an Amazon Aurora Replica: By creating a read replica in Amazon Aurora, you have an additional instance that can serve read traffic. In the event of a failover, the replica can be promoted to the primary instance, reducing downtime. Explanation: C. Use RDS Proxy in front of the database: RDS Proxy acts as an intermediary between the application and the RDS database. It helps improve scalability, availability, and failover times. During a failover, RDS Proxy maintains established connections, reducing the time required for the application to reconnect to the database. D. Migrate the database to Amazon Aurora MySQL: Amazon Aurora is a highly available and durable database service that offers faster failovers compared to traditional RDS for MySQL. It uses a distributed storage architecture and automatic replica promotion to minimize downtime during failovers. E. Create an Amazon Aurora Replica: By creating a read replica in Amazon Aurora, you have an additional instance that can serve read traffic. In the event of a failover, the replica can be promoted to the primary instance, reducing downtime. Option A is incorrect because using Amazon ElastiCache for Memcached in front of the database does not directly address the failover time reduction requirement. Option B is incorrect because using Amazon ElastiCache for Redis in front of the database does not directly address the failover time reduction requirement. Option F is incorrect because creating an RDS for MySQL read replica does not directly address the failover time reduction requirement. Therefore, the correct combination of steps is C, D, and E: Use RDS Proxy in front of the database, migrate the database to Amazon Aurora MySQL, and create an Amazon Aurora Replica.