Minimizing Credential Overhead for EC2 and Aurora
A company has an application that runs on Amazon EC2 instances and uses an Amazon Aurora database. The EC2 instances connect to the database by using user names and passwords that are stored locally in a file. The company wants to minimize the operational overhead of credential management. What should a solutions architect do to accomplish this goal?
Community Insight
The question tests which AWS service can both store and automatically rotate database credentials, and the common trap is assuming Parameter Store offers native rotation or that re-hosting the file on S3/EBS reduces management effort.
This SAA-C03 scenario asks how an EC2-hosted application should stop storing Aurora user names and passwords in a local file while cutting credential-management overhead. AWS Secrets Manager with automatic rotation is the correct answer (A), because it centrally stores, encrypts, and rotates database credentials without manual intervention.
Option B is the most common wrong pick because learners associate Parameter Store with secrets, but it has no built-in rotation capability unless you build and run your own Lambda-based rotation logic yourself.
Community Discussion (113 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
AWS Secrets Manager is purpose-built to store, retrieve, and rotate credentials throughout their lifecycle, and it ships with native rotation support for Amazon Aurora, Amazon RDS MySQL/PostgreSQL and other engines via a Lambda rotation function. Turning on automatic rotation removes the manual cycle of updating the local credential file, so the EC2 application simply calls GetSecretValue at runtime and always receives fresh, KMS-encrypted credentials. This directly satisfies the stated goal of minimizing operational overhead of credential management while eliminating the plaintext file on disk. As hro noted, "Aurora manages the settings for the secret and rotates the secret every seven days by default."Why the Other Options Are Wrong
Option B fails because Systems Manager Parameter Store does not support automatic rotation natively; as Sinaneos stated, "parameter store does not support auto rotation, unless the customer writes it themselves." Option C merely relocates the same credential file into an S3 object, which still requires the application to fetch and parse a static file, adds an S3 dependency, and ogerber warned "never store credentials on buckets, its a hazard." Option D is equally weak: an encrypted EBS volume is still a locally mounted file per instance, so every rotation forces manual file updates on each EC2 instance and multiplies operational work instead of reducing it.Community Comment Notes
The comment thread converges strongly on A, with PhucVuu framing the trade-off as "Improve security with lowest operational overhead" and KVK16 pointing to Secrets Manager's "built-in integrations for MySQL, PostgreSQL, and Amazon Aurora." cookieMr emphasized that the application "can retrieve the database credentials programmatically at runtime," which matches the recommended integration pattern. Abishek016 summarized the consensus that automatic rotation "ensures that the EC2 instances retrieve the most recent credentials securely." One commenter, NaaVeeN, questioned how answers get marked correct, which is a workflow concern rather than a technical one.Official Reference
Exam Strategy
When a question says to minimize operational overhead around credentials, immediately look for automatic rotation — Secrets Manager is the only AWS service offering it natively for RDS/Aurora. Eliminate any option that keeps the secret in a file-like store, since relocation to S3 or EBS does not reduce rotation work.
Frequently Asked Questions
Why can't I use Parameter Store to rotate the Aurora credentials automatically?
Parameter Store has no built-in rotation engine for database credentials. You would have to author, deploy, and maintain your own Lambda rotation function, which defeats the goal of minimizing operational overhead.
Why is moving the credential file to an S3 bucket or EBS volume not enough?
S3 and EBS only relocate the stored file; the application still reads static credentials and someone must still update the file on every rotation. Neither service performs automatic credential rotation for you.
Related Analysis
Practice All SAA-C03 Questions
Access 120 questions with complete answers and detailed explanations.
View Full SAA-C03 Practice Test →
AWS Secrets managerif it requires auto rotation ``` To implement password rotation lifecycles, use AWS Secrets Manager. You can rotate, manage, and retrieve database credentials, API keys, and other secrets throughout their lifecycle using Secrets Manager. For more information, see What is AWS Secrets Manager? in the AWS Secrets Manager User Guide.