The correct answer is: A. To achieve this goal, a solutions architect should use AWS Secrets Manager and turn on automatic rotation.
This option is correct because AWS Secrets Manager is specifically designed to securely store, manage, and rotate credentials such as database usernames and passwords. It integrates natively with Amazon Aurora, supports automatic rotation without downtime, and provides secure API access for applications. This removes the need for storing credentials locally on EC2 instances, minimizing operational overhead and improving security.
More details: AWS Secrets Manager documentation
Option B: Incorrect because AWS Systems Manager Parameter Store can store secrets but does not natively provide automatic rotation. Implementing rotation would require additional Lambda and CloudWatch setup, increasing operational overhead.
Option C: Incorrect because storing credentials in Amazon S3 (even with KMS encryption) is not recommended for secret management. S3 lacks native credential rotation and fine-grained secret handling features.
Option D: Incorrect because using encrypted Amazon EBS volumes only secures credentials at rest. It does not address credential rotation, centralized storage, or application-level retrieval.
Summary: Option A is correct because AWS Secrets Manager provides the simplest, most secure, and automated way to handle Aurora database credentials with minimal operational effort.