AWS Certified Data Engineer – Associate (DEA-C01) — Question 184

A company wants to migrate a data warehouse from Teradata to Amazon Redshift.

Which solution will meet this requirement with the LEAST operational effort?

Answer options

• A. Use AWS Database Migration Service (AWS DMS) Schema Conversion to migrate the schema. Use AWS DMS to migrate the data.
• B. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data.
• C. Use AWS Database Migration Service (AWS DMS) to migrate the data. Use automatic schema conversion.
• D. Manually export the schema definition from Teradata. Apply the schema to the Amazon Redshift database. Use AWS Database Migration Service (AWS DMS) to migrate the data.

Correct answer: B

Explanation

The correct answer is B because using the AWS Schema Conversion Tool (AWS SCT) specifically addresses the schema migration efficiently, while AWS DMS facilitates the data transfer. The other options either involve manual processes or less effective tools, resulting in greater operational effort.