Question 225 of 307
Single answerAn aerospace company uses a proprietary data format to store its flight data. You need to connect this new data source to BigQuery and stream the data into
BigQuery. You want to efficiently import the data into BigQuery while consuming as few resources as possible. What should you do?
AWrite a shell script that triggers a Cloud Function that performs periodic ETL batch jobs on the new data source.
BUse a standard Dataflow pipeline to store the raw data in BigQuery, and then transform the format later when the data is used.
CUse Apache Hive to write a Dataproc job that streams the data into BigQuery in CSV format.
✓DUse an Apache Beam custom connector to write a Dataflow pipeline that streams the data into BigQuery in Avro format.
✓
Correct Answer: D
Use an Apache Beam custom connector to write a Dataflow pipeline that streams the data into BigQuery in Avro format.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.