nerdexam
Amazon

SAP-C02 · Question #79

A company warns to migrate a 30 TB Oracle data warehouse from on premises to Amazon Redshift. The company used the AWS Schema Conversion Tool (AWS SCT) to convert the schema of the existing data wareh

The correct answer is D. Create a job in AWS Snowball Edge to import data into Amazon S3 Install AWS SCT extraction. Transfer 30TB over 50Mbps will take around 53Days that ruled out ABC.

Submitted by brentm· Mar 6, 2026Migrate Workloads and Modernize Solutions

Question

A company warns to migrate a 30 TB Oracle data warehouse from on premises to Amazon Redshift. The company used the AWS Schema Conversion Tool (AWS SCT) to convert the schema of the existing data warehouse to an Amazon Redshift schema. The company also used a migration assessment report to identify manual tasks to complete. The company needs to migrate the data to the new Amazon Redshift cluster during an upcoming data freeze period of 2 weeks. The only network connection between the on-premises data warehouse and AWS is a 50 Mops internet connection. Which migration strategy meets these requirements?

Options

  • ACreate an AWS Database Migration Service (AWS DMS) replication instance.
  • BInstall the AWS SCT extraction agents on the on-premises servers.
  • Cinstall the AWS SCT extraction agents on the on-premises servers.
  • DCreate a job in AWS Snowball Edge to import data into Amazon S3 Install AWS SCT extraction

How the community answered

(17 responses)
  • A
    18% (3)
  • B
    12% (2)
  • C
    6% (1)
  • D
    65% (11)

Explanation

Transfer 30TB over 50Mbps will take around 53Days that ruled out ABC.

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice