Your company has a large quantity of unstructured data in different file formats. You want to perform ETL transformations on the data. You need to make the data accessible on Google Cloud so it can…

The correct answer is B. Upload the data to Cloud Storage using the gsutil command line tool. For unstructured data use cloud storage. Use Big Query for analytics, data warehouse with structured data. https://cloud.google.com/solutions/performing-etl-from-relational-database-into-bigquery

Submitted by ravi_2018· Mar 30, 2026Deploying and implementing a cloud solution

Question

Your company has a large quantity of unstructured data in different file formats. You want to perform ETL transformations on the data. You need to make the data accessible on Google Cloud so it can be processed by a Dataflow job. What should you do?

Options

AUpload the data to BigQuery using the bq command line tool.
BUpload the data to Cloud Storage using the gsutil command line tool.
CUpload the data into Cloud SQL using the import function in the console.
DUpload the data into Cloud Spanner using the import function in the console.

How the community answered

(32 responses)

A
3% (1)
B
88% (28)
C
6% (2)
D
3% (1)

Explanation

For unstructured data use cloud storage. Use Big Query for analytics, data warehouse with structured data. https://cloud.google.com/solutions/performing-etl-from-relational-database-into-bigquery

Topics

#Cloud Storage#gsutil#Dataflow ETL#unstructured data ingestion

Community Discussion

No community discussion yet for this question.

Full ASSOCIATE-CLOUD-ENGINEER Practice