GCP ACE · Question 27 · Domain 3.4: Deploying and implementing data solutions
You have a large CSV file containing historical sales data stored in a Cloud Storage bucket (gs://my-data-bucket/sales.csv). You need to load this data into an existing BigQuery table named 'sales_history' in the 'analytics' dataset.
Which command-line tool and command should you use?
Answer options:
gsutil cp gs://my-data-bucket/sales.csv bq://analytics/sales_history
gcloud bigquery import gs://my-data-bucket/sales.csv analytics.sales_history
bq load analytics.sales_history gs://my-data-bucket/sales.csv
bq query --destination_table=analytics.sales_history 'SELECT * FROM gs://my-data-bucket/sales.csv'
50 questions · hints · full answers · grading
Expert