Google Professional Data Engineer

Google Professional Data Engineer

Get started today

Ultimate access to all questions.


How can BigQuery be utilized as a data sink in terms of writing modes?




Explanation:

When employing a BigQueryIO.Write transform in batch mode for writing to a single table, Dataflow initiates a BigQuery load job. Conversely, when using a BigQueryIO.Write transform in streaming mode or in batch mode with a function to define the destination table, Dataflow leverages BigQuery's streaming inserts. For more details, refer to: https://cloud.google.com/dataflow/model/bigquery-io