Google Cloud Associate Cloud Engineer — Question 244

You are planning to migrate your on-premises data to Google Cloud. The data includes:

• 200 TB of video files in SAN storage
• Data warehouse data stored on Amazon Redshift
• 20 GB of PNG files stored on an S3 bucket

You need to load the video files into a Cloud Storage bucket, transfer the data warehouse data into BigQuery, and load the PNG files into a second Cloud Storage bucket. You want to follow Google-recommended practices and avoid writing any code for the migration. What should you do?

Answer options

• A. Use gcloud storage for the video files, Dataflow for the data warehouse data, and Storage Transfer Service for the PNG files.
• B. Use Transfer Appliance for the videos, BigQuery Data Transfer Service for the data warehouse data, and Storage Transfer Service for the PNG files.
• C. Use Storage Transfer Service for the video files, BigQuery Data Transfer Service for the data warehouse data, and Storage Transfer Service for the PNG files.
• D. Use Cloud Data Fusion for the video files, Dataflow for the data warehouse data, and Storage Transfer Service for the PNG files.

Correct answer: B

Explanation

The correct answer is B because Transfer Appliance is a suitable solution for migrating large volumes of data like 200 TB of video files. Additionally, the BigQuery Data Transfer Service is designed for transferring data from other sources into BigQuery, making it ideal for the data warehouse data from Amazon Redshift, while Storage Transfer Service is appropriate for moving the PNG files into Cloud Storage. The other options either involve solutions that require coding or do not align with Google’s recommended practices for these specific tasks.