nerdexam
GoogleGoogle

PROFESSIONAL-DATA-ENGINEER · Question #264

PROFESSIONAL-DATA-ENGINEER Question #264: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #264. The question stem and answer options stay visible for context.

Submitted by thandi_sa· Mar 30, 2026Designing data processing systems

Question

An aerospace company uses a proprietary data format to store its night data. You need to connect this new data source to BigQuery and stream the data into BigQuery. You want to efficiency import the data into BigQuery where consuming as few resources as possible. What should you do?

Options

  • AUse a standard Dataflow pipeline to store the raw data in BigQuery and then transform the format later when the data is used.
  • BWrite a shell script that triggers a Cloud Function that performs periodic ETL batch jobs on the new data source
  • 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

Unlock PROFESSIONAL-DATA-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Data streaming#Dataflow#Custom connectors#BigQuery ingestion#Proprietary data
Full PROFESSIONAL-DATA-ENGINEER PracticeBrowse All PROFESSIONAL-DATA-ENGINEER Questions