ExpertMedium1 markMultiple Choice
GCP ACE · Question 27 · Domain 3.4: Deploying and implementing data solutions
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?
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:
A.
gcloud bigquery load
B.
gsutil cp
C.
bq load
D.
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
bq load
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.
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...EasyQ02A new team member has joined your operations team. They need to be able to view all Compute Engin...MediumQ03Your company is migrating to Google Cloud. You currently manage all employee identities in an on-...MediumQ04Your development team is experimenting with new GCP services in a sandbox project. The finance te...MediumQ05Your company wants to perform complex, custom SQL analysis on their Google Cloud billing data to ...Easy