A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet this requirement with the LEAST operational effort?

The correct answer is B. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database. This solution provides the least operational effort for migrating a data warehouse from Teradata to Amazon Redshift by using AWS services that are specifically designed for schema and data AWS Schema Conversion Tool (SCT) is used to convert and migrate the schema from Teradata…

Data Ingestion and Transformation

Question

Options

AUse AWS Database Migration Service (AWS DMS) Schema Conversion to migrate the schema.
BUse the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database
CUse AWS Database Migration Service (AWS DMS) to migrate the data. Use automatic schema
DManually export the schema definition from Teradata. Apply the schema to the Amazon Redshift

How the community answered

(24 responses)

A
13% (3)
B
79% (19)
C
4% (1)
D
4% (1)

Explanation

This solution provides the least operational effort for migrating a data warehouse from Teradata to Amazon Redshift by using AWS services that are specifically designed for schema and data AWS Schema Conversion Tool (SCT) is used to convert and migrate the schema from Teradata to Amazon Redshift, handling schema differences automatically and reducing manual work. AWS Database Migration Service (DMS) is then used to transfer the data from Teradata to Redshift, allowing for efficient data migration.

Topics

#Data Migration#AWS SCT#AWS DMS#Amazon Redshift

Community Discussion

No community discussion yet for this question.

Full DEA-C01 Practice