Google Cloud Professional Data Engineer — Question 318
Your platform on your on-premises environment generates 100 GB of data daily, composed of millions of structured JSON text files. Your on-premises environment cannot be accessed from the public internet. You want to use Google Cloud products to query and explore the platform data. What should you do?
Answer options
- A. Use Cloud Scheduler to copy data daily from your on-premises environment to Cloud Storage. Use the BigQuery Data Transfer Service to import data into BigQuery.
- B. Use a Transfer Appliance to copy data from your on-premises environment to Cloud Storage. Use the BigQuery Data Transfer Service to import data into BigQuery.
- C. Use Transfer Service for on-premises data to copy data from your on-premises environment to Cloud Storage. Use the BigQuery Data Transfer Service to import data into BigQuery.
- D. Use the BigQuery Data Transfer Service dataset copy to transfer all data into BigQuery.
Correct answer: C
Explanation
The correct answer is C because the Transfer Service for on-premises data is specifically designed to facilitate the secure transfer of data from an on-premises environment to Google Cloud Storage. Option A requires Cloud Scheduler, which is not ideal for large data volumes, while option B, though valid, involves physical appliances which may not be necessary for daily transfer. Option D does not address the need for an initial data transfer to Cloud Storage from the on-premises environment.