SAP-C02 Question 603
Select 2A company is migrating their on-premises Oracle database to Amazon Aurora PostgreSQL. The Oracle database uses custom PL/SQL code for stored procedures, and the company wants to minimize downtime during the migration. Which combination of actions will help achieve this requirement?
- A
Use AWS Schema Conversion Tool (AWS SCT) to analyze the Oracle database schema and convert the database schema and PL/SQL code to Aurora PostgreSQL-compatible formats.
- B
Use AWS Database Migration Service (AWS DMS) in full load plus change data capture (CDC) mode to migrate the data from the Oracle database to Aurora PostgreSQL with minimal downtime.
- C
Manually rewrite the PL/SQL code from the Oracle database to be compatible with Aurora PostgreSQL before using AWS DMS to migrate the data.
- D
Use AWS DMS to automatically convert the Oracle database schema and PL/SQL code to Aurora PostgreSQL-compatible formats during the data migration.
- E
Deploy an Aurora Read Replica during the migration process to ensure high availability.
Show answer and explanation
Correct answers: A, B
Explanation
Migrating an on-premises Oracle database to Amazon Aurora PostgreSQL involves two key steps: schema conversion and data migration. AWS SCT is the appropriate tool for converting the Oracle database schema and PL/SQL code to formats compatible with Aurora PostgreSQL. AWS DMS can then be used to migrate the data with minimal downtime by enabling full load plus CDC mode. This combination of tools ensures a smooth migration process while meeting the company's requirement to minimize downtime.
- A. Correct.
This is correct. AWS SCT is used to analyze and convert the database schema and associated code, such as PL/SQL, to a format compatible with the target database engine.
- B. Correct.
This is correct. AWS DMS in full load plus CDC mode ensures minimal downtime by continuously replicating changes from the source database to the target database during migration.
- C. Incorrect.
This is incorrect. Manually rewriting PL/SQL code is time-consuming and error-prone. AWS SCT is specifically designed to handle such conversions automatically.
- D. Incorrect.
This is incorrect. AWS DMS does not convert database schemas or PL/SQL code. Schema and code conversion must be performed using AWS SCT or other tools before data migration.
- E. Incorrect.
This is incorrect. Aurora Read Replicas are not relevant to the migration process and are instead used for scaling read operations and ensuring high availability for an existing Aurora database.