ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 105 - SAP-C02 discussion

Report
Export

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.)


A.
Use Amazon ElastiCache for Memcached in front of the database
Answers
A.
Use Amazon ElastiCache for Memcached in front of the database
B.
Use Amazon ElastiCache for Redis in front of the database.
Answers
B.
Use Amazon ElastiCache for Redis in front of the database.
C.
Use RDS Proxy in front of the database
Answers
C.
Use RDS Proxy in front of the database
D.
Migrate the database to Amazon Aurora MySQL
Answers
D.
Migrate the database to Amazon Aurora MySQL
E.
Create an Amazon Aurora Replica
Answers
E.
Create an Amazon Aurora Replica
F.
Create an RDS for MySQL read replica
Answers
F.
Create an RDS for MySQL read replica
Suggested answer: C, D, E

Explanation:

Migrate the database to Amazon Aurora MySQL. - Create an Amazon Aurora Replica. - Use RDS Proxy in front of the database. - These options are correct because they address the requirement of reducing the failover time to less than 20 seconds. Migrating to Amazon Aurora MySQL and creating an Aurora replica can reduce the failover time to less than 20 seconds. Aurora has a built-in, fault-tolerant storage system that can automatically detect and repair failures. Additionally, Aurora has a feature called 'Aurora Global Database' which allows you to create read-only replicas across multiple AWS regions which can further help to reduce the failover time. Creating an Aurora replica can also help to reduce the failover time as it can take over as the primary DB instance in case of a failure. Using RDS proxy can also help to reduce the failover time as it can route the queries to the healthy DB instance, it also helps to balance the load across multiple DB instances.

asked 16/09/2024
Kurt Onal
30 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first