A company runs its databases on Amazon RDS for PostgreSQL. The company wants a secure solution to manage the master user password by rotating the password every 30 days. Which solution will meet these requirements with the LEAST operational overhead?
AUse Amazon EventBridge to schedule a custom AWS Lambda function to rotate the password every 30 days.
BUse the modify-db-instance command in the AWS CLI to change the password.
CIntegrate AWS Secrets Manager with Amazon RDS for PostgreSQL to automate password rotation.
DIntegrate AWS Systems Manager Parameter Store with Amazon RDS for PostgreSQL to automate password rotation.