Domain 4.3: Migration Strategy — AWS SAP-C02 Practice Question 64

How to approach this question

Identify the two standard AWS tools used together for heterogeneous database migrations.

Full Answer

A.Use the AWS Schema Conversion Tool (SCT) to convert the schema and stored procedures. Use AWS Database Migration Service (DMS) with Change Data Capture (CDC) for the data migration.✓ Correct

Migrating from Oracle to PostgreSQL is a heterogeneous migration. You must use the AWS Schema Conversion Tool (SCT) to convert the source schema and custom code (PL/SQL) to a format compatible with the target database (PL/pgSQL). Once the schema is converted, you use AWS Database Migration Service (DMS) to migrate the actual data. By enabling Change Data Capture (CDC) in DMS, ongoing changes are replicated, allowing you to cut over to the new database with near-zero downtime.

Common mistakes

Assuming DMS can convert schemas and stored procedures on its own.

An enterprise is migrating a large Oracle database to Amazon Aurora PostgreSQL. The database contains complex PL/SQL stored procedures. The migration must be completed with minimal downtime. Which combination of AWS tools should the Architect use to perform this migration?

How to approach this question

Full Answer

Common mistakes

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 5

More questions from this exam