AWS Certified Database – Specialty — Question 150

A company is planning on migrating a 500-GB database from Oracle to Amazon Aurora PostgreSQL using the AWS Schema Conversion Tool (AWS SCT) and
AWS DMS. The database does not have any stored procedures to migrate but has some tables that are large or partitioned. The application is critical for business so a migration with minimal downtime is preferred.
Which combination of steps should a database specialist take to accelerate the migration process? (Choose three.)

Answer options

• A. Use the AWS SCT data extraction agent to migrate the schema from Oracle to Aurora PostgreSQL.
• B. For the large tables, change the setting for the maximum number of tables to load in parallel and perform a full load using AWS DMS.
• C. For the large tables, create a table settings rule with a parallel load option in AWS DMS, then perform a full load using DMS.
• D. Use AWS DMS to set up change data capture (CDC) for continuous replication until the cutover date.
• E. Use AWS SCT to convert the schema from Oracle to Aurora PostgreSQL.
• F. Use AWS DMS to convert the schema from Oracle to Aurora PostgreSQL and for continuous replication.

Correct answer: D, E

Explanation

The correct steps include using AWS SCT to convert the schema from Oracle to Aurora PostgreSQL and setting up change data capture (CDC) with AWS DMS for continuous replication. Options A, B, C, and F do not align with the requirement for minimal downtime and effectively accelerating the migration process.