QuestionQ56

VerifiedContinuous Improvement for Existing Solutions

A security engineer has found that an existing application obtains credentials for an Amazon RDS for MySQL database from an encrypted file in Amazon S3. For the application’s next version, the security engineer wants to make these design changes to improve security:

  • The database must use strong, randomly generated passwords that are stored in a secure AWS managed service.
  • Application resources must be deployed through AWS CloudFormation.
  • The application must rotate database credentials every 90 days.

A solutions architect will create a CloudFormation template to deploy the application.

Which resources specified in the CloudFormation template meet the security engineer’s requirements with the LEAST operational overhead?

Explanation

AWS Secrets Manager can generate and encrypt a random database password through the GenerateSecretString property of an AWS::SecretsManager::Secret. An AWS::SecretsManager::RotationSchedule configures a secret’s rotation rules and invokes its Lambda rotation function on the specified schedule, allowing Amazon RDS for MySQL credentials to be rotated every 90 days. This is the native CloudFormation and Secrets Manager mechanism; Parameter Store has no RotationSchedule resource, and AppSync does not perform database credential rotation.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!