Which combination of actions should a database specialist take to accomplish this migration as quickly as possible?
(Choose two.)
Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. Then restore the converted schema to the target Aurora DB cluster.
Use Oracle’s Data Pump tool to export a copy of the source database schema and manually edit the schema in a text editor to make it compatible with Aurora.
Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Select the migration type to replicate ongoing changes to keep the source and target databases in sync until the company is ready to move all user traffic to the Aurora DB cluster.
Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS Kinesis Data Firehose stream to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
Create an AWS Glue job and related resources to migrate data from the Oracle database to the Aurora DB cluster. Once the initial load is complete, create an AWS DMS task to perform change data capture (CDC) until the company is ready to move all user traffic to the Aurora DB cluster.
Explanations:
AWS Schema Conversion Tool (SCT) is useful for converting the Oracle schema to a format compatible with Aurora. After conversion, the schema can be restored to Aurora for the database migration.
Editing the schema manually with a text editor is error-prone and time-consuming, and AWS SCT provides a more reliable and automated method for schema conversion.
AWS DMS (Database Migration Service) with ongoing replication can synchronize data between the Oracle database and Aurora, allowing for write traffic on both databases until the final cutover is made.
AWS DMS is sufficient for data migration and ongoing replication. Using Kinesis Data Firehose for CDC adds unnecessary complexity and isn’t necessary when AWS DMS already supports ongoing replication.
While AWS Glue is a suitable service for data migration, it is not designed for handling ongoing replication (CDC). AWS DMS should be used for that purpose instead of Glue.
If I’m not mistaken, the answer is:
Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. Then restore the converted schema to the target Aurora DB cluster.
To the best of my knowledge, the answer is:
Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. Then restore the converted schema to the target Aurora DB cluster.