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

Vendor: Google
Product: Professional-Data-Engineer
Update on: Jan 30, 2026
Questions: 387

Google Professional-Data-Engineer Question Answer

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?

Use bq load to load a batch of sensor data every 60 seconds.

Use a Cloud Dataflow pipeline to stream data into the BigQuery table.

Use the INSERT statement to insert a batch of data every 60 seconds.

Use the MERGE statement to apply updates in batch every 60 seconds.