A company needs to migrate a 50 TB Oracle database from their on-premises data center to Amazon RDS for PostgreSQL. The migration must have near-zero downtime. Which combination of AWS services should be used?

Answer options:

AWS DataSync and Amazon S3.

AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).

AWS Application Migration Service (MGN).

AWS Snowball Edge and native Oracle export/import tools.

How to approach this question

Identify the tools for heterogeneous database migration (SCT) and continuous replication (DMS).

Full Answer

B.AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).✓ Correct

AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).

For heterogeneous migrations (Oracle to PostgreSQL), AWS SCT is used to convert the database schema. AWS DMS is then used to migrate the data and keep the source and target in sync until the cutover, enabling near-zero downtime.

Common mistakes

Choosing MGN, which cannot change the database engine during migration.

Question 32 All questions Question 34

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

75 questions · hints · full answers · grading

More questions from this exam

Q01An enterprise has 50 VPCs across two AWS Regions. They need to establish transitive routing betwe...Hard Q02A company uses AWS Organizations. The security team wants to ensure that no IAM user or role can ...Medium Q03An application requires a relational database with an RPO of 1 second and an RTO of less than 1 m...Hard Q04A company is setting up a new multi-account environment. They want to automate the provisioning o...Medium Q05An organization wants to allocate AWS costs to specific business units. They use AWS Organization...Hard

View all 75 questions →