nerdexam
Amazon

SAP-C02 · Question #481

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. https://docs.aws.amazon.com/secretsmanager/latest/userguide/rotate-secrets_turn-on-for- other.html#rotate-secrets_turn-on-for-other_step1

Submitted by ricky.ec· Mar 6, 2026Migrate Workloads and Modernize Solutions

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 the 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 the AWS Schema Conversion Tool (AWS

How the community answered

(36 responses)
  • A
    6% (2)
  • B
    83% (30)
  • C
    3% (1)
  • D
    8% (3)

Explanation

https://docs.aws.amazon.com/secretsmanager/latest/userguide/rotate-secrets_turn-on-for- other.html#rotate-secrets_turn-on-for-other_step1

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice