Question

A logistics company wants operations managers to see near real-time package scan data in their analytics dashboards. Delivery events arrive continuously from thousands of handheld scanners, and analysts want to query the latest events within seconds of them being generated, without waiting for scheduled batch loads. Which approach best supports making this data useful and immediately queryable?

Accepted Answer

Stream the scan events into BigQuery so records become available for querying almost immediately after ingestion

Answer

Export scan events to CSV files and run a nightly batch load into BigQuery

Answer

Store the raw scan events in Cloud Storage and query them only after a weekly aggregation job

Answer

Load the scan events into a Cloud SQL instance and replicate them to BigQuery once per day