ExpertMedium1 markMultiple Choice
GCP ACE · Question 26 · Domain 3.4: Deploying and implementing data solutions
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?
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:
A.
gcloud bigquery load ./data.csv company_metrics.sales_data
B.
gsutil cp ./data.csv bq://company_metrics/sales_data
C.
bq load --source_format=CSV company_metrics.sales_data ./data.csv
D.
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
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.
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...EasyQ02You are managing access to a GCP project. You need to grant 15 developers the ability to view Com...MediumQ03You have created a new GCP project using the Cloud Console. You want to deploy a Cloud Function u...EasyQ04Your startup has a strict monthly cloud budget of $500. You want to be notified immediately if yo...EasyQ05Your finance team wants to perform complex SQL analysis on your GCP billing data to understand co...Medium