SOA-C03 · Question #71
A company requires the rotation of administrative credentials for production workloads on a regular basis. A CloudOps engineer must implement this policy for an Amazon RDS DB instance's master user…
The correct answer is D. Create a new RDS database secret in AWS Secrets Manager. Apply the secret to the RDS DB. AWS Secrets Manager natively supports credential management and automatic rotation for Amazon RDS master user passwords. When a secret is associated with an RDS instance, Secrets Manager automatically updates the password both in the secret and on the database, without downtime…
Question
A company requires the rotation of administrative credentials for production workloads on a regular basis. A CloudOps engineer must implement this policy for an Amazon RDS DB instance's master user password. Which solution will meet this requirement with the LEAST operational effort?
Options
- ACreate an AWS Lambda function to change the RDS master user password. Create an Amazon
- BCreate a new SecureString parameter in AWS Systems Manager Parameter Store. Encrypt the
- CCreate a new String parameter in AWS Systems Manager Parameter Store. Configure automatic
- DCreate a new RDS database secret in AWS Secrets Manager. Apply the secret to the RDS DB
How the community answered
(42 responses)- A5% (2)
- B7% (3)
- C17% (7)
- D71% (30)
Explanation
AWS Secrets Manager natively supports credential management and automatic rotation for Amazon RDS master user passwords. When a secret is associated with an RDS instance, Secrets Manager automatically updates the password both in the secret and on the database, without downtime or manual scripting. "AWS Secrets Manager can automatically rotate the master user password for Amazon RDS databases. Rotation is fully managed and integrated, requiring no custom code or maintenance." Option A introduces unnecessary Lambda automation. Option B and C use Parameter Store, which does not provide direct RDS password rotation. Therefore, Option D achieves secure, automatic credential rotation with least operational effort, fully aligned with CloudOps security automation principles.
Topics
Community Discussion
No community discussion yet for this question.