AWS Certified Database – Specialty — Question 112

A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster. The company requires a very low RTO and needs to improve the application recovery time after database failovers.
Which approach meets these requirements?

Answer options

• A. Set the max_connections parameter to 16,000 in the instance-level parameter group.
• B. Modify the client connection timeout to 300 seconds.
• C. Create an Amazon RDS Proxy database proxy and update client connections to point to the proxy endpoint.
• D. Enable the query cache at the instance level.

Correct answer: C

Explanation

Creating an Amazon RDS Proxy allows for better management of database connections and can significantly reduce application downtime during failovers, thus meeting the low RTO requirement. The other options, while potentially useful for different scenarios, do not directly enhance the recovery time after database failovers.