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?

Answer options:

Use AWS Database Migration Service (DMS) to migrate both the schema and the data.

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.

Export the Oracle database to CSV files, transfer via AWS Snowball, and use the PostgreSQL COPY command.

Use AWS Application Migration Service (MGN) to replicate the Oracle server to EC2.

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

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.

Question 42 All questions Question 44

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

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is redesigning its network architecture across 50 AWS accounts. They require ...Hard Q02A financial services company uses AWS Organizations to manage 100+ accounts. The security team ma...Medium Q03An e-commerce company requires a multi-region active-active architecture for its critical order p...Medium Q04A company is setting up a new AWS environment using AWS Control Tower. They need to ensure that a...Hard Q05An enterprise has 50 AWS accounts under AWS Organizations. They want to implement a chargeback mo...Medium

View all 75 questions →