AWS Certified Solutions Architect - Professional
Get started today
Ultimate access to all questions.
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?
Explanation:
The correct answer is A. Implementing an Amazon RDS Proxy layer in front of the database instance helps manage large numbers of connections efficiently by establishing a connection pool and reusing existing connections, which reduces the overhead on the database instance. Storing the connection credentials as a secret in AWS Secrets Manager enhances security and allows for automatic rotation of the credentials. These features collectively ensure that the application can handle the current connection load while keeping the credentials secure and providing automatic rotation.