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

Which command-line tool and command should you use?

Answer options:

gcloud bigquery load

gsutil cp

bq load

bq insert

How to approach this question

Remember that BigQuery has its own dedicated CLI tool (bq) and identify the command for bulk ingestion.

Full Answer

C.bq load✓ Correct

The `bq` command-line tool is used to interact with BigQuery. To bulk load data from a file (like a CSV in Cloud Storage) into a BigQuery table, the correct command is `bq load`.

Common mistakes

Assuming `gcloud` handles BigQuery data operations, or using `gsutil` which only handles file transfers.

Question 26 All questions Question 28

Practice the full GCP Associate Cloud Engineer Practice Exam 3

50 questions · hints · full answers · grading

More questions from this exam

Q01You are starting a new project in Google Cloud and need to create a new GCP project and enable th...Easy Q02A new team member has joined your operations team. They need to be able to view all Compute Engin...Medium Q03Your company is migrating to Google Cloud. You currently manage all employee identities in an on-...Medium Q04Your development team is experimenting with new GCP services in a sandbox project. The finance te...Medium Q05Your company wants to perform complex, custom SQL analysis on their Google Cloud billing data to ...Easy

View all 50 questions →