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

How to approach this question

Recognize that heterogeneous migrations require SCT for schema and DMS for data.

Full Answer

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

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

For heterogeneous database migrations (e.g., Oracle to PostgreSQL), the AWS Schema Conversion Tool (SCT) is required to translate the schema, views, and stored procedures. AWS DMS is then used to move the data, and CDC ensures near-zero downtime by keeping the target in sync until cutover.

Common mistakes

Assuming DMS can convert complex stored procedures.

An enterprise is migrating a 50 TB Oracle database to Amazon Aurora PostgreSQL. The migration must have near-zero downtime. The source database uses complex stored procedures and proprietary Oracle features. How should the Solutions Architect execute this migration?

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam