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 a 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 a BigQuery table named 'sales_data' in the 'finance' dataset.
Which command-line tool and command should you use?
Answer options:
A.
gsutil cp gs://my-bucket/data.csv bq://finance/sales_data
B.
gcloud bigquery load gs://my-bucket/data.csv finance.sales_data
C.
bq load finance.sales_data gs://my-bucket/data.csv
D.
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
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.
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...EasyQ02Your company uses Google Workspace. You need to grant a new developer, Alice, the ability to view...MediumQ03You have created a new GCP project and want to deploy a Compute Engine instance. However, when yo...MediumQ04Your startup has a strict monthly cloud budget of $500. You want to be notified via email when yo...EasyQ05Your finance team wants to analyze Google Cloud costs using standard SQL and build custom dashboa...Medium