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?

Answer options:

AWS Application Migration Service (MGN) to replicate the database server.

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

AWS Snowball Edge to transfer the data, and AWS DMS to convert the schema.

Export the Oracle database to CSV, upload to S3, and use AWS Glue to load into Aurora.

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

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.

Question 36 All questions Question 38

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

75 questions · hints · full answers · grading

More questions from this exam

Q01A company is setting up a multi-account AWS environment using AWS Organizations. They need to ens...Easy Q02An enterprise needs to connect its on-premises data center to AWS. They require a dedicated, priv...Easy Q03A company wants to share a single AWS Transit Gateway across multiple AWS accounts within their A...Easy Q04An architect needs to design a highly available database architecture that spans multiple AWS Reg...Easy Q05A global financial institution is migrating its core banking application to AWS. The application ...Medium

View all 75 questions →