Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test

As a GCP data engineer, you were asked to use Cloud shell to load the Big query dataset with the data available in Google Cloud Storage.

Google Cloud Storage path: gs://whizlabs-public-dataset/department/cloudcertcount.csv

Big query Table: whizlabs_dataset.cloud_cert_dataset

Data format : CSV

Schema : Name:STRING,CERTIFICATION:STRING,AGE:INTEGER

Can you suggest which one of the following is correct? ( select one)

A. bq load –source_format = CSV

whizlabs_dataset.cloud_cert_dataset

gs://whizlabs-public-dataset/department/cloudcertcount.csv

Name:STRING,CERTIFICATION:STRING,AGE:INTEGER
B. bq extract –source_format = CSV

whizlabs_dataset.cloud_cert_dataset

gs://whizlabs-public-dataset/department/cloudcertcount.csv

Name:STRING,CERTIFICATION:STRING,AGE:INTEGER
C. bq load –schema

Name:STRING,CERTIFICATION:STRING,AGE:INTEGER –source_format = CSV

whizlabs_dataset.cloud_cert_dataset

gs://whizlabs-public-dataset/department/cloudcertcount.csv
D. bq load –target_format = CSV

whizlabs_dataset.cloud_cert_dataset

gs://whizlabs-public-dataset/department/cloudcertcount.csv

Name:STRING,CERTIFICATION:STRING,AGE:INTEGER

Correct Answer: A

Options A is CORRECT because the current syntax is :
bq load –source_format = [format] [destination dataset].[table] [source_path] [schema]

bq load –source_format = CSV whizlabs_dataset.cloud_cert_dataset gs://whizlabs-public-dataset/department/cloudcertcount.csv Name:STRING,CERTIFICATION:STRING,AGE:INTEGER

bq load command is to load data into a Big Query table.

Option B is incorrect because the bq extract command is used to export table data to Google Cloud Storage.

All the other options are invalid.

For more information on the Big Query-bq load, please visit the below URL: