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 (gs://my-data-bucket/sales.csv). You need to load this data into a BigQuery table named sales_data in the finance dataset.
Which command should you use?
Answer options:
gsutil cp gs://my-data-bucket/sales.csv bq://finance/sales_data
gcloud bigquery load gs://my-data-bucket/sales.csv finance.sales_data
bq load --source_format=CSV finance.sales_data gs://my-data-bucket/sales.csv
bq import gs://my-data-bucket/sales.csv finance.sales_data
50 questions · hints · full answers · grading