You have a 50 GB CSV file stored locally on your on-premises server. You need to load this data into a BigQuery table named 'sales_data' in the dataset 'company_metrics'.

Which command should you use?

Answer options:

gcloud bigquery load ./data.csv company_metrics.sales_data

gsutil cp ./data.csv bq://company_metrics/sales_data

bq load --source_format=CSV company_metrics.sales_data ./data.csv

bq import ./data.csv company_metrics.sales_data

How to approach this question

Identify the specific CLI tool used for BigQuery and the command for ingesting data.

Full Answer

C.bq load --source_format=CSV company_metrics.sales_data ./data.csv✓ Correct

bq load --source_format=CSV company_metrics.sales_data ./data.csv

The `bq` command-line tool is used to interact with BigQuery. The `bq load` command is used to load data into a table. The syntax requires specifying the format, the destination table (dataset.table), and the source file.

Common mistakes

Trying to use `gcloud` or `gsutil` for BigQuery data loading.

Question 25 All questions Question 27

Practice the full GCP Associate Cloud Engineer Practice Exam 2

50 questions · hints · full answers · grading

More questions from this exam

Q01Your company is migrating to Google Cloud and needs to establish a resource hierarchy. You have t...Easy Q02You are managing access to a GCP project. You need to grant 15 developers the ability to view Com...Medium Q03You have created a new GCP project using the Cloud Console. You want to deploy a Cloud Function u...Easy Q04Your startup has a strict monthly cloud budget of $500. You want to be notified immediately if yo...Easy Q05Your finance team wants to perform complex SQL analysis on your GCP billing data to understand co...Medium

View all 50 questions →