nerdexam
Amazon

SAP-C02 · Question #54

A company plans to migrate to AWS. A solutions architect uses AWS Application Discovery Service over the fleet and discovers that there is an Oracle data warehouse and several PostgreSQL databases…

The correct answer is B. Migrate the Oracle data warehouse to Amazon Redshift using AWS SCT and AWS QMS. D. Migrate the PostgreSQL databases to Amazon RDS for PostgreSQL using AWS DMS. https://aws.amazon.com/getting-started/hands-on/migrate-oracle-to-amazon-redshift/ https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises- postgresql-database-to-amazon-rds-for-postgresql.html

Submitted by yaw92· Mar 6, 2026Migrate Workloads and Modernize Solutions

Question

A company plans to migrate to AWS. A solutions architect uses AWS Application Discovery Service over the fleet and discovers that there is an Oracle data warehouse and several PostgreSQL databases. Which combination of migration patterns will reduce licensing costs and operational overhead? (Choose two.)

Options

  • ALift and shift the Oracle data warehouse to Amazon EC2 using AWS DMS.
  • BMigrate the Oracle data warehouse to Amazon Redshift using AWS SCT and AWS QMS.
  • CLift and shift the PostgreSQL databases to Amazon EC2 using AWS DMS.
  • DMigrate the PostgreSQL databases to Amazon RDS for PostgreSQL using AWS DMS
  • EMigrate the Oracle data warehouse to an Amazon EMR managed cluster using AWS DMS.

How the community answered

(47 responses)
  • A
    15% (7)
  • B
    77% (36)
  • C
    6% (3)
  • E
    2% (1)

Explanation

https://aws.amazon.com/getting-started/hands-on/migrate-oracle-to-amazon-redshift/ https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises- postgresql-database-to-amazon-rds-for-postgresql.html

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice