A company is migrating a PostgreSQL database to AWS and wants database credentials that are stored securely and automatically rotated, with no additional application code changes. Which option meets these requirements?

The correct option is to use Amazon Aurora PostgreSQL and store credentials in AWS Secrets Manager with rotation enabled. Amazon Aurora PostgreSQL is a fully managed relational database service compatible with PostgreSQL, making it suitable for a PostgreSQL migration. AWS Secrets Manager is designed for securely storing and automatically rotating database credentials, API keys, and other secrets. It integrates directly with Aurora databases for automatic rotation without requiring application code changes. Using Amazon Systems Manager Parameter Store is incorrect because while it can store secrets, its automatic rotation capabilities are not as robust or integrated for database credentials as Secrets Manager, and it typically requires more manual setup or custom solutions for rotation. Using Amazon DynamoDB is incorrect because it is a NoSQL database, not a relational database, and therefore not a suitable migration target for a PostgreSQL database.