Domain 3.4: Deploying and implementing data solutions — GCP ACE Practice Question 27

How to approach this question

Identify the correct CLI tool for BigQuery (bq) and the correct verb for ingesting data (load).

Full Answer

A.bq load analytics.sales gs://my-bucket/sales_data.csv✓ Correct

bq load analytics.sales gs://my-bucket/sales_data.csv

To interact with BigQuery from the command line, you use the `bq` tool. The specific command to ingest data from a file (local or in Cloud Storage) into a BigQuery table is `bq load`. The syntax is `bq load [DATASET].[TABLE] [SOURCE_FILE]`.

Common mistakes

Trying to use `gsutil cp` to copy into BigQuery, or guessing the verb is 'import' instead of 'load'.

You have a large CSV file stored in a Cloud Storage bucket (`gs://my-bucket/sales_data.csv`). You need to load this data into an existing BigQuery table named `sales` in the `analytics` dataset.

Which command should you use?

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Associate Cloud Engineer Practice Exam 5

More questions from this exam

You have a large CSV file stored in a Cloud Storage bucket (gs://my-bucket/sales_data.csv). You need to load this data into an existing BigQuery table named sales in the analytics dataset. Which command should you use?

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Associate Cloud Engineer Practice Exam 5

More questions from this exam

You have a large CSV file stored in a Cloud Storage bucket (`gs://my-bucket/sales_data.csv`). You need to load this data into an existing BigQuery table named `sales` in the `analytics` dataset.

Which command should you use?