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?

Answer options:

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.

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

Use AWS Application Migration Service (MGN) to replicate the Oracle server to an EC2 instance, then use pg_dump to move data to Aurora.

Export the Oracle database using Data Pump, upload to Amazon S3, and use the Aurora PostgreSQL import feature.

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

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.

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.

Question 63 All questions Question 65

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

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is redesigning its AWS network architecture across 50 AWS accounts and 3 AWS ...Hard Q02A company uses AWS Organizations to manage multiple accounts. The security team mandates that no ...Medium Q03A financial institution requires a disaster recovery strategy for its critical trading applicatio...Hard Q04An enterprise is setting up a new multi-account AWS environment using AWS Control Tower. They nee...Medium Q05A company has a complex AWS environment with hundreds of linked accounts under AWS Organizations....Hard

View all 75 questions →