Google Cloud Professional Data Engineer PDE — Topic 1 Question 323

Question

You need to load a dataset with multiple terabytes of clickstream data into BigQuery. The data arrives each day as compressed JSON files in a Cloud Storage bucket. You need a low-cost, programmatic, and scalable solution to load the data into BigQuery. What should you do?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Create an external table in BigQuery pointing to the Cloud Storage bucket and run the INSERT INTO... SELECT * FROM external_table command. Cloud Storage provides durable, scalable object storage that is fully managed. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Google Cloud Professional Data Engineer PDE — Question 323