nerdexam
Amazon

SAA-C03 · Question #737

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. Migrating the database to Amazon RDS for Oracle allows managed database operations. Storing the database password in AWS Secrets Manager with automatic rotation minimizes operational overhead and ensures compliance with the yearly password rotation requirement.

Submitted by cyberguy42· Mar 4, 2026Design Secure Architectures

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

(45 responses)
  • A
    2% (1)
  • B
    91% (41)
  • D
    7% (3)

Explanation

Migrating the database to Amazon RDS for Oracle allows managed database operations. Storing the database password in AWS Secrets Manager with automatic rotation minimizes operational overhead and ensures compliance with the yearly password rotation requirement.

Community Discussion

No community discussion yet for this question.

Full SAA-C03 Practice