AWS Certified Database – Specialty — Question 53

A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server. Due to escalating support and maintenance costs, the company is exploring the option of moving the workload to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?

Answer options

• A. Perform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing row counts from source and target tables.
• B. Run AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of the objects migrated by comparing the row counts from source and target tables.
• C. Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate the migration compatibility.
• D. Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster. Create a migration assessment report to evaluate the migration compatibility.

Correct answer: D

Explanation

The correct answer is D because the AWS Schema Conversion Tool (AWS SCT) is specifically designed to evaluate the compatibility of database schemas and suggest changes for migration, providing a systematic assessment. Options A and B involve manual processes that may not fully capture all compatibility issues, while option C focuses on replication rather than compatibility assessment.