GCP PDE · Preparing and using data for analysis

A revenue operations analyst at a mid-size company wants to explore a large BigQuery sales table directly with pivot tables and native spreadsheet formulas, without exporting or duplicating the data, and needs the results to stay live as the underlying table updates. Which approach should the analyst use?

• AExport the BigQuery table results to a CSV file and re-import it into Sheets each week.
• BBuild a Looker Studio report on the table and embed the report inside the Sheets file.
• CWrite an Apps Script that runs a BigQuery job and pastes the results into cells whenever it is executed.
• DUse Connected Sheets to link Google Sheets directly to the BigQuery table.