
Ultimate access to all questions.
A solutions architect is tasked with enhancing an application hosted on AWS, which utilizes an Amazon Aurora MySQL database instance that is currently overwhelmed by connection requests. The application primarily performs record insertions into the database and currently manages credentials in a plain text configuration file. To address the connection overload, the solutions architect must devise a solution that not only accommodates the current connection demand but also ensures the security of the credentials and supports automatic credential rotation on a regular basis. Which of the following solutions meets these criteria?
A
Implement an Amazon RDS Proxy layer in front of the database instance and store the connection credentials securely as a secret in AWS Secrets Manager.
B
Establish an Amazon RDS Proxy layer in front of the database instance and store the connection credentials in AWS Systems Manager Parameter Store.
C
Set up an Aurora Replica and store the connection credentials securely as a secret in AWS Secrets Manager.
D
Configure an Aurora Replica and store the connection credentials in AWS Systems Manager Parameter Store.