Question

Your team ingests JSON events from IoT sensors into Pub/Sub and needs to land them in a BigQuery table for near-real-time dashboards. The events already match the target table schema, require no transformation or enrichment, and the team wants to minimize operational overhead and cost. Which approach best meets these requirements?

Accepted Answer

Create a Pub/Sub BigQuery subscription that writes messages directly to the BigQuery table using its schema.

Answer

Deploy a streaming Dataflow pipeline that reads from Pub/Sub and writes to BigQuery using the streaming inserts API.

Answer

Configure a Pub/Sub subscription that writes to Cloud Storage, then schedule a batch load job into BigQuery every hour.

Answer

Use a Dataproc Spark Structured Streaming job to consume from Pub/Sub and write to BigQuery with the connector.