You have a 50 GB CSV file stored in a Cloud Storage bucket. You need to load this data into a BigQuery table named 'sales_data' in the 'finance' dataset.

Which command-line tool and command should you use?

Answer options:

gsutil cp gs://my-bucket/data.csv bq://finance/sales_data

gcloud bigquery load gs://my-bucket/data.csv finance.sales_data

bq load finance.sales_data gs://my-bucket/data.csv

bq import gs://my-bucket/data.csv finance.sales_data

How to approach this question

Identify the specific CLI tool used for BigQuery operations.

Full Answer

C.bq load finance.sales_data gs://my-bucket/data.csv✓ Correct

bq load finance.sales_data gs://my-bucket/data.csv

The `bq` command-line tool is used to interact with BigQuery. The `bq load` command loads data from a source (like a local file or a Cloud Storage URI) into a BigQuery table. The syntax is `bq load [DATASET].[TABLE] [SOURCE]`.

Common mistakes

Trying to use `gsutil` or `gcloud` for BigQuery data loading.

Question 26 All questions Question 28

Practice the full GCP Associate Cloud Engineer Practice Exam 4

50 questions · hints · full answers · grading

More questions from this exam

Q01You have recently joined a new team and need to set up a new Google Cloud project for a developme...Easy Q02Your company uses Google Workspace. You need to grant a new developer, Alice, the ability to view...Medium Q03You have created a new GCP project and want to deploy a Compute Engine instance. However, when yo...Medium Q04Your startup has a strict monthly cloud budget of $500. You want to be notified via email when yo...Easy Q05Your finance team wants to analyze Google Cloud costs using standard SQL and build custom dashboa...Medium

View all 50 questions →