SAP-C02 Question 273

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose ACE2

  Option E - https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/ Option A - https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle-postgresql.migration-process.database-schema-conversion.html

• 1

  B. Use the AWS Schema Conversion Tool (AWS SCT) to create a new RDS for PostgreSQL DB instance in the target account with the schema and initial data from the source database. C. Configure VPC peering between the VPCs in the two AWS accounts to provide connectivity to both DB instances from the target account. E. Use AWS Database Migration Service (AWS DMS) in the target account to perform a full load plus change data capture (CDC) migration from the source database to the target database. When the migration is complete, change the CNAME record to point to the target DB instance endpoint.

• Chose ACE1

  Answer - ACE Create target DB and use SCT for Schema conversion VPC peering and Open DB access ports via SGs AWS DMS to fully load + CDC