A logistics manager wants a Looker Studio scorecard to reflect shipments as they land in a BigQuery table, with no manual steps in between. Which data source configuration should be chosen?
Show answer and explanation
Answer: B
A live BigQuery connection makes Looker Studio send queries to the table whenever a chart refreshes, so the scorecard reflects new rows without a copy step. Extract-based sources hold a snapshot that must be refreshed on a schedule, and uploaded files or PDF emails are static. Only the live connection meets the requirement of no manual steps and near-current data.
Why the other options are wrong
- A. A CSV upload is a static snapshot. Every new shipment would require someone to upload a fresh file, which breaks the no-manual-steps requirement.
- C. An extract is a copy of the data that depends on refresh timing and manual action. Between refreshes, the scorecard shows stale shipment counts.
- D. A PDF export is a frozen picture of the scorecard and is not connected to the data at all. It cannot update as shipments arrive.