SAP-C02 Question 606
Select 3A company is migrating its on-premises Oracle database to Amazon Aurora PostgreSQL. The database contains custom PL/SQL code. The migration must minimize downtime and ensure compatibility with the target database. Which combination of steps should the solutions architect take to achieve this?
- A
Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema and custom PL/SQL code to a format compatible with Aurora PostgreSQL.
- B
Use AWS Database Migration Service (AWS DMS) in full-load mode to migrate the data from the Oracle database to Aurora PostgreSQL.
- C
Use AWS DMS with change data capture (CDC) enabled to replicate ongoing changes from the Oracle database to Aurora PostgreSQL after the full load.
- D
Manually rewrite the custom PL/SQL code to be compatible with PostgreSQL before migrating the schema.
- E
Use AWS SCT to create a migration assessment report to identify schema conversion issues before migration.
Show answer and explanation
Correct answers: A, C, E
Explanation
To migrate an Oracle database with custom PL/SQL code to Aurora PostgreSQL, using AWS SCT is essential to convert schemas and custom code to a compatible format. AWS SCT's migration assessment report helps identify compatibility issues early on. AWS DMS with CDC ensures that ongoing changes to the source database are replicated to the target database, minimizing downtime during the migration. This combination of tools and strategies ensures a smooth and efficient migration process.
- A. Correct.
Correct: AWS SCT can convert the schema and custom PL/SQL code to a PostgreSQL-compatible format, automating much of the compatibility work.
- B. Incorrect.
Incorrect: Full-load mode alone does not account for ongoing changes during the migration process, potentially causing data inconsistencies.
- C. Correct.
Correct: Using AWS DMS with CDC ensures that ongoing changes in the source database are replicated to the target database, minimizing downtime.
- D. Incorrect.
Incorrect: Manually rewriting custom PL/SQL code can be time-consuming and error-prone. AWS SCT is designed to automate this process where possible.
- E. Correct.
Correct: Generating an assessment report with AWS SCT helps identify potential compatibility issues and plan the migration effectively.