A company must migrate its customer transactions database from on-premises to AWS. The current database is Oracle on a Linux server. A new security requirement mandates rotating the database password annually. Which solution meets the requirements with the LEAST operational overhead?
Choose an answer
Tap an option to check your answer.
Correct answer: Migrate the database to Amazon RDS for Oracle. Store the database credentials in AWS Secrets Manager and enable automatic rotation, scheduling it to rotate yearly..
Why this is the answer
Migrating to Amazon RDS for Oracle directly supports the existing Oracle database, minimizing conversion effort. AWS Secrets Manager is purpose-built for storing and automatically rotating database credentials, including annual schedules, offering the least operational overhead for password management. Converting to DynamoDB or Neptune with AWS SCT would involve significant schema and application refactoring, increasing complexity and operational overhead. While Systems Manager Parameter Store can store passwords, it requires a custom Lambda function and CloudWatch alarm for rotation, which is more operational overhead than Secrets Manager's built-in automation. Migrating to EC2 instances for the database means managing the OS, database software, and patching, which is higher operational overhead than RDS.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed