Which AWS service or capability will meet these requirements?
Amazon S3
AWS Systems Manager Parameter Store
AWS Secrets Manager
AWS CloudTrail
Explanations:
Amazon S3 is a storage service mainly used for storing and retrieving large volumes of unstructured data, not for securely storing or managing sensitive credentials.
AWS Systems Manager Parameter Store can store secrets but does not natively support automatic password rotation for Amazon RDS credentials.
AWS Secrets Manager is designed for securely storing credentials, and it supports automatic rotation of RDS database passwords.
AWS CloudTrail is used for logging and monitoring AWS account activity but is not meant for storing or rotating secrets or database credentials.