Which approach meets these requirements?

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

View Answer

Answer: C

Explanation:

Amazon RDS Proxy allows applications to pool and share connections established with the database, improving database efficiency and application scalability. With RDS Proxy, failover times for Aurora and RDS databases are reduced by up to 66% and database credentials, authentication, and access can be managed through integration with AWS Secrets Manager and AWS Identity and Access Management (IAM). https://aws.amazon.com/rds/proxy/