Your on-prem environment (no public internet) generates 100 GB/day of structured JSON files. How should you move and import this data into BigQuery for querying and exploration?
Choose an answer
Tap an option to check your answer.
Correct answer: 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..
Why this is the answer
The correct approach is to use Transfer Service for on-premises data to move the 100 GB/day of JSON files from your air-gapped environment to Cloud Storage. This service is designed for large-scale, automated data transfers from private data centers to Google Cloud. Once the data is in Cloud Storage, the BigQuery Data Transfer Service can then be used to import the structured JSON files into BigQuery tables. Using Cloud Scheduler is incorrect because it orchestrates tasks but doesn't directly facilitate large-scale data transfer from an on-premise environment without internet access. A Transfer Appliance is suitable for one-time or infrequent large-volume transfers, not for daily, ongoing transfers. The BigQuery Data Transfer Service dataset copy is for copying data between BigQuery datasets, not for ingesting external data from on-premises sources.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed