nerdexam
Amazon

SAP-C02 · Question #469

A solutions architect needs to improve an application that is hosted in the AWS Cloud. The application uses an Amazon Aurora MySQL DB instance that is experiencing overloaded connections. Most of…

The correct answer is A. Deploy an Amazon RDS Proxy layer. In front of the DB instance. Store the connection credentials. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html

Submitted by skyler.x· Mar 6, 2026Continuous Improvement for Existing Solutions

Question

A solutions architect needs to improve an application that is hosted in the AWS Cloud. The application uses an Amazon Aurora MySQL DB instance that is experiencing overloaded connections. Most of the application's operations insert records into the database. The application currently stores credentials in a text-based configuration file. The solutions architect needs to implement a solution so that the application can handle the current connection load. The solution must keep the credentials secure and must provide the ability to rotate the credentials automatically on a regular basis. Which solution will meet these requirements?

Options

  • ADeploy an Amazon RDS Proxy layer. In front of the DB instance. Store the connection credentials
  • BDeploy an Amazon RDS Proxy layer in front of the DB instance. Store the connection credentials
  • CCreate an Aurora Replica. Store the connection credentials as a secret in AWS Secrets Manager
  • DCreate an Aurora Replica. Store the connection credentials in AWS Systems Manager Parameter

How the community answered

(39 responses)
  • A
    72% (28)
  • B
    15% (6)
  • C
    8% (3)
  • D
    5% (2)

Explanation

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice