Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
Your current on-premises environment generates 100 GB of data daily, consisting of millions of structured JSON text files. Due to security restrictions, this environment cannot be accessed from the public internet. You want to leverage Google Cloud resources to query and analyze this data effectively. What steps should you take to accomplish this?
Explanation:
The correct option is 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'. This is because the Transfer Service for on-premises data is designed specifically for secure transfer of data from on-premises environments to Google Cloud, without requiring access to the public internet. Option A is incorrect because Cloud Scheduler is not designed for data transfer but for scheduling tasks. Option B is incorrect because Transfer Appliance is intended for one-time bulk transfers, not daily transfers. Option D is incorrect because the BigQuery Data Transfer Service dataset copy feature is for copying datasets between BigQuery projects, not from on-premises systems.