A company plans to migrate a data warehouse from Teradata to Amazon Redshift. Which option requires the least operational effort to perform the migration?
Choose an answer
Tap an option to check your answer.
Correct answer: Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data..
Why this is the answer
The correct option leverages AWS SCT for schema migration and AWS DMS for data migration, which is the recommended and most efficient approach for heterogeneous database migrations like Teradata to Redshift. AWS SCT specializes in converting database schemas and code objects (like stored procedures, views, and functions) from one database engine to another, identifying and reporting on any incompatibilities. AWS DMS then handles the actual data transfer, including ongoing replication if needed. "AWS Database Migration Service (AWS DMS) Schema Conversion" is not a distinct service; schema conversion is handled by AWS SCT. "Automatic schema conversion" is not a feature of AWS DMS for heterogeneous migrations; AWS SCT is required. Manually exporting and applying the schema is labor-intensive and prone to errors, significantly increasing operational effort compared to using AWS SCT.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed