AWS Certified Database – Specialty — Question 205

A company wants to move its on-premises Oracle database to an Amazon Aurora PostgreSQL DB cluster. The source database includes 500 GB of data. 900 stored procedures and functions, and application source code with embedded SQL statements. The company understands there are some database code objects and custom features that may not be automatically converted and may need some manual intervention. Management would like to complete this migration as fast as possible with minimal downtime.

Which tools and approach should be used to meet these requirements?

Answer options

• A. Use AWS DMS to perform data migration and to automatically create all schemas with Aurora PostgreSQL
• B. Use AWS DMS to perform data migration and use the AWS Schema Conversion Tool (AWS SCT) to automatically generate the converted code
• C. Use the AWS Schema Conversion Tool (AWS SCT) to automatically convert all types of Oracle schemas to PostgreSQL and migrate the data to Aurora
• D. Use the dump and pg_dump utilities for both data migration and schema conversion

Correct answer: B

Explanation

The correct answer is B because using AWS DMS for data migration along with AWS SCT allows for the effective conversion of the database schema and code. Option A does not address the need for code conversion, while option C focuses solely on schema conversion without the data migration aspect. Option D is less efficient as it requires manual intervention and does not integrate the tools as effectively as option B does.