Explanation:
AWS SCT is purpose-built for heterogeneous schema migrations like Teradata to Redshift. It handles complex SQL dialect differences, data type mappings, and stored procedure conversions automatically, producing an assessment report. Once the schema is converted and applied, AWS DMS handles the data migration efficiently. This separation of schema and data migration is the standard AWS recommended approach with the least manual effort.
Ultimate access to all questions.
Question 17.
A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet this requirement with the LEAST operational effort?
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.
No comments yet.