The correct answer is B. AWS Secrets Manager is specifically designed to manage secrets, such as database credentials, and supports automatic rotation of those secrets according to a predefined schedule. This makes it the most secure and automated solution for rotating database passwords every 30 days, ensuring compliance with security policies. Other options either do not support automatic rotation or do not provide an equally secure and managed approach.