hiexam
google · Professional-Data-Engineer · Q426 · multiple_choice · topic_1

You have a requirement to insert minute-resolution data from 50,000 sensors into a BigQuery table. You expect significa…

You have a requirement to insert minute-resolution data from 50,000 sensors into a BigQuery table. You expect significant growth in data volume and need the data to be available within 1 minute of ingestion for real-time analysis of aggregated trends. What should you do?
  • A.Use bq load to load a batch of sensor data every 60 seconds.
  • B.Use a Cloud Dataflow pipeline to stream data into the BigQuery table.
  • C.Use the INSERT statement to insert a batch of data every 60 seconds.
  • D.Use the MERGE statement to apply updates in batch every 60 seconds.
Explanation
I think we need a pipeline, so it's B to me.

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.