A Company Uses Amazon RDS for PostgreSQL Databases for Its

Multiple Choice

A company uses Amazon RDS for PostgreSQL databases for its data tier. The company must implement password rotation for the databases. Which solution meets this requirement with the LEAST operational overhead?

A) Store the password in AWS Secrets Manager. Enable automatic rotation on the secret.
B) Store the password in AWS Systems Manager Parameter Store. Enable automatic rotation on the parameter.
C) Store the password in AWS Systems Manager Parameter Store. Write an AWS Lambda function that rotates the password.
D) Store the password in AWS Key Management Service (AWS KMS) . Enable automatic rotation on the customer master key (CMK) .