SAA-C03 · Question #421
A company needs to migrate its customer transactions database from on-premises to AWS. The database resides on an Oracle DB instance that runs on a Linux server. According to a new security…
The correct answer is B. Migrate the database to Amazon RDS for Oracle. Store the password in AWS Secrets Manager. Amazon RDS for Oracle is a managed database service, which significantly reduces operational overhead compared to running Oracle on EC2 or on-premises. AWS Secrets Manager natively integrates with RDS and supports automatic, scheduled password rotation with minimal setup. You…
Question
A company needs to migrate its customer transactions database from on-premises to AWS. The database resides on an Oracle DB instance that runs on a Linux server. According to a new security requirement, the company must rotate the database password each year. Which solution will meet these requirements with the LEAST operational overhead?
Options
- AConvert the database to Amazon DynamoDB by using AWS Schema Conversion Tool (AWS
- BMigrate the database to Amazon RDS for Oracle. Store the password in AWS Secrets Manager.
- CMigrate the database to an Amazon EC2 instance. Use AWS Systems Manager Parameter Store
- DMigrate the database to Amazon Neptune by using AWS Schema Conversion Tool (AWS SCT).
How the community answered
(28 responses)- A4% (1)
- B75% (21)
- C14% (4)
- D7% (2)
Explanation
Amazon RDS for Oracle is a managed database service, which significantly reduces operational overhead compared to running Oracle on EC2 or on-premises. AWS Secrets Manager natively integrates with RDS and supports automatic, scheduled password rotation with minimal setup. You can configure the rotation schedule (including yearly), and Secrets Manager will handle the secure password storage and rotation workflow for you.
Community Discussion
No community discussion yet for this question.