Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A company in the aerospace industry has flight data stored in a proprietary format. You are tasked with importing this data into BigQuery efficiently, with minimal resource consumption. Which of the following options would you choose?
A
Write a Dataproc job using Apache Hive to stream the data into BigQuery in CSV format.
B
Use a shell script that triggers a Cloud Function for periodic ETL batch jobs on the new data source.
C
Use a standard Dataflow pipeline to store the raw data in BigQuery, then transform the format later when the data is used.
D
Use a custom connector with Apache Beam to write a Dataflow pipeline that streams the data into BigQuery in Avro format.
