Google Associate Cloud Engineer Question 146
Select 2Google Cloud PlatformYou are working as a Cloud Engineer for a retail company that needs to load customer transaction data into BigQuery for analysis. The data is currently stored in CSV files on Google Cloud Storage. Which of the following steps should you take to efficiently load this data into BigQuery?
- A
Use the BigQuery Data Transfer Service to schedule a transfer from Cloud Storage.
- B
Use the BigQuery Console to create a load job specifying the Cloud Storage URI.
- C
Configure Cloud Functions to trigger on new file uploads to load data into BigQuery.
- D
Use the bq command-line tool to load the data from Cloud Storage to BigQuery.
- E
Move the data to a local machine and then upload it to BigQuery using the BigQuery API.
Show answer and explanation
Correct answers: B, D
Explanation
To efficiently load data from Google Cloud Storage into BigQuery, you can use the BigQuery Console or the bq command-line tool. Both methods allow you to directly specify the Cloud Storage URI of the files you want to load, making them efficient and straightforward options for this task.
- A. Incorrect.
The BigQuery Data Transfer Service is used for transferring data from SaaS applications, not for loading files from Cloud Storage.
- B. Correct.
The BigQuery Console can be used to create a load job directly from Cloud Storage by specifying the URI of the CSV files.
- C. Incorrect.
While Cloud Functions can be used for automated workflows, it is not the most straightforward or efficient method for this task.
- D. Correct.
The bq command-line tool is a suitable choice for loading data into BigQuery, allowing you to specify the Cloud Storage URI as the source.
- E. Incorrect.
Moving the data to a local machine introduces unnecessary complexity and is not an efficient approach compared to direct loading from Cloud Storage.