The correct answer is C: Employ AWS Secrets Manager to store credentials with a configuration for daily rotation to meet the security requirement. AWS Secrets Manager allows you to securely store and automatically rotate database credentials. By setting up daily rotation in Secrets Manager, you ensure that the credentials are rotated frequently enough to meet the weekly rotation requirement set by the security team.