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

How to approach this question

Identify the tools for heterogeneous database migration.

Full Answer

B.AWS Schema Conversion Tool (SCT) to convert the schema, and AWS Database Migration Service (DMS) with Change Data Capture (CDC) for the data transfer.✓ Correct

AWS Schema Conversion Tool (SCT) to convert the schema, and AWS Database Migration Service (DMS) with Change Data Capture (CDC) for the data transfer.

For heterogeneous migrations (e.g., Oracle to PostgreSQL), AWS SCT converts the schema and code. AWS DMS migrates the data. Enabling CDC in DMS keeps the target in sync with the source, allowing for near-zero downtime cutover.

Common mistakes

Confusing the roles of SCT and DMS.

A company is migrating a legacy Oracle database to Amazon Aurora PostgreSQL. The database is 5 TB and requires minimal downtime during the cutover. Which combination of AWS services should the architect use?

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam