An enterprise architecture consists of a primary production workload running on Amazon ECS in the us-east-1 region, and a testing suite running in a secondary development AWS account. The production ECS tasks must connect to a Multi-AZ Amazon Aurora PostgreSQL database. The security policy mandates that database credentials must be rotated every 30 days without application downtime, and all sensitive data at rest must be encrypted using a customer managed key (CMK). Additionally, a non-sensitive configuration file containing public API endpoints must be shared with the testing suite in the development account. The operations team wants to implement these requirements while minimizing ongoing AWS costs and administrative overhead. Which design meets these requirements?
- Store the database credentials in AWS Secrets Manager and configure automatic rotation every 30 days using the AWS-provided rotation Lambda function. Encrypt the secret using a KMS customer managed key (CMK). Store the non-sensitive public API endpoints as standard String parameters in Systems Manager Parameter Store, and allow the development account to access them by assuming a cross-account IAM role in the production account.Answer
- BStore the database credentials as SecureString parameters in Systems Manager Parameter Store. Configure AWS KMS to automatically rotate the customer managed key (CMK) every 30 days, which will rotate the underlying database password. Store the public API endpoints as String parameters in Parameter Store, and apply a resource-based policy to share them with the development account.
- CStore both the database credentials and the public API endpoints as standard String parameters in Systems Manager Parameter Store to eliminate Secrets Manager costs. Create an Amazon EventBridge rule that runs every 30 days to trigger a custom AWS Lambda function that rotates the database credentials and updates the Parameter Store values.
- DStore the database credentials in AWS Secrets Manager and the public API endpoints in AWS Secrets Manager. Enable automatic rotation on the KMS customer managed key (CMK) encrypting the database credentials secret, which will automatically rotate the database password in RDS and re-encrypt all historical database backups under the new key version.