AWS Certified Solutions Architect – Professional — Question 300

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.)

Answer options

• A. Lift and shift the Oracle data warehouse to Amazon EC2 using AWS DMS.
• B. Migrate the Oracle data warehouse to Amazon Redshift using AWS SCT and AWS DMS
• C. Lift and shift the PostgreSQL databases to Amazon EC2 using AWS DMS.
• D. Migrate the PostgreSQL databases to Amazon RDS for PostgreSQL using AWS DMS.
• E. Migrate the Oracle data warehouse to an Amazon EMR managed cluster using AWS DMS.

Correct answer: D, E

Explanation

Migrating the PostgreSQL databases to Amazon RDS for PostgreSQL (Option D) minimizes operational overhead by leveraging a fully managed database service that automates backups, patching, and scaling. Transferring the Oracle data warehouse to a managed Amazon EMR cluster (Option E) eliminates high Oracle licensing costs by shifting to open-source big data frameworks while lowering management effort through EMR's managed environment. Running databases on Amazon EC2 (Options A and C) does not reduce operational overhead, as the administration of the operating system and database software remains the customer's responsibility.