nerdexam
Google

PROFESSIONAL-DATA-ENGINEER · Question #84

You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?

The correct answer is B. Drain. Explanation/Reference: When you apply a BigQueryIO.Write transform in batch mode to write to a single table, Dataflow invokes a BigQuery load job. When you apply a BigQueryIO.Write You have a job that you want to cancel. It is a streaming pipeline, and you want to ensure that…

Submitted by fernanda_arg· Mar 30, 2026Building and operationalizing data processing systems

Question

You want to use a BigQuery table as a data sink. In which writing mode(s) can you use BigQuery as a sink?

Options

  • ACancel
  • BDrain
  • CStop
  • DFinish

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    94% (30)
  • D
    3% (1)

Explanation

Explanation/Reference: When you apply a BigQueryIO.Write transform in batch mode to write to a single table, Dataflow invokes a BigQuery load job. When you apply a BigQueryIO.Write You have a job that you want to cancel. It is a streaming pipeline, and you want to ensure that any data that is in-flight is processed and written to the output. Which of the following commands can you use on the Dataflow monitoring console to stop the pipeline job? Explanation/Reference: Using the Drain option to stop your job tells the Dataflow service to finish your job in its current state. Your job will immediately stop ingesting new data from input sources, but the Dataflow service will preserve any existing resources (such as worker instances) to finish processing and writing any buffered data in your

Topics

#BigQuery#Dataflow#data sink#drain mode

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER Practice