An organization is migrating a massive on-premises data warehouse to Amazon Redshift. The data volume is 500 TB. The on-premises internet connection is 1 Gbps, but only 200 Mbps can be allocated for the migration. The migration must be completed within 3 weeks. Which data transfer strategy is feasible and MOST cost-effective?

Answer options:

Order multiple AWS Snowball Edge Storage Optimized devices. Copy the data locally, ship them to AWS, and import the data into Amazon S3. Use the COPY command to load data into Redshift.

Use AWS DataSync to transfer the data directly to Amazon S3 over the internet connection. Load the data into Redshift.

Establish a new 10 Gbps AWS Direct Connect dedicated connection. Use AWS Database Migration Service (DMS) to replicate the data to Redshift.

Order an AWS Snowmobile to transfer the data directly to Amazon Redshift.

How to approach this question

Calculate the network transfer time (500TB @ 200Mbps = ~230 days). Since it exceeds 3 weeks, an offline transfer method is required.

Full Answer

A.Order multiple AWS Snowball Edge Storage Optimized devices. Copy the data locally, ship them to AWS, and import the data into Amazon S3. Use the COPY command to load data into Redshift.✓ Correct

Order multiple AWS Snowball Edge Storage Optimized devices. Copy the data locally, ship them to AWS, and import the data into Amazon S3. Use the COPY command to load data into Redshift.

To transfer 500 TB over a 200 Mbps link would take approximately 231 days. Because the deadline is 3 weeks, an offline migration strategy is mandatory. AWS Snowball Edge Storage Optimized devices hold 80 TB of usable capacity each. Ordering several devices allows parallel local copying, shipping, and loading into S3, easily meeting the 3-week deadline.

Common mistakes

Failing to do the mental math on transfer speeds and choosing an online method like DataSync.

Question 15 All questions Question 17

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

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is redesigning its AWS network architecture across 50 AWS accounts and 3 AWS ...Hard Q02A company uses AWS Organizations to manage multiple accounts. The security team mandates that no ...Medium Q03A financial institution requires a disaster recovery strategy for its critical trading applicatio...Hard Q04An enterprise is setting up a new multi-account AWS environment using AWS Control Tower. They nee...Medium Q05A company has a complex AWS environment with hundreds of linked accounts under AWS Organizations....Hard

View all 75 questions →