A data analytics company is migrating a 500 TB data warehouse to Amazon Redshift. The data is currently stored in an on-premises Hadoop cluster. The migration must be completed quickly, but the company's internet connection is only 100 Mbps. Which THREE steps form the BEST migration strategy? (Select THREE)

Answer options:

Order multiple AWS Snowball Edge Storage Optimized devices.

Copy the Hadoop data to the Snowball devices and ship them to AWS to be loaded into Amazon S3.

Use the Amazon Redshift COPY command to load the data from S3 into Redshift.

Use AWS DataSync to transfer the data over the internet connection.

Use AWS Database Migration Service (DMS) to migrate directly from Hadoop to Redshift.

Use AWS Snowmobile.

How to approach this question

Recognize the need for offline transfer (Snowball) due to bandwidth constraints, and the standard Redshift ingestion pattern (S3 -> COPY).

Full Answer

Order multiple AWS Snowball Edge Storage Optimized devices. Copy the Hadoop data to the Snowball devices and ship them to AWS to be loaded into Amazon S3. Use the Amazon Redshift COPY command to load the data from S3 into Redshift.

Due to the slow internet connection, offline transfer using AWS Snowball Edge is necessary. Snowball imports the data into Amazon S3. Once in S3, the Amazon Redshift COPY command is the fastest and most scalable method to load the data into the Redshift cluster.

Common mistakes

Choosing DataSync, ignoring the math of 500 TB over 100 Mbps.

Question 63 All questions Question 65

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 1

75 questions · hints · full answers · grading

More questions from this exam

Q01An enterprise has 50 VPCs across two AWS Regions. They need to establish transitive routing betwe...Hard Q02A company uses AWS Organizations. The security team wants to ensure that no IAM user or role can ...Medium Q03An application requires a relational database with an RPO of 1 second and an RTO of less than 1 m...Hard Q04A company is setting up a new multi-account environment. They want to automate the provisioning o...Medium Q05An organization wants to allocate AWS costs to specific business units. They use AWS Organization...Hard

View all 75 questions →