GCP PCA · Question 48 · Domain 5: Managing Implementation and Ensuring Reliability
Your data analytics team runs massive SQL queries on BigQuery. The CFO has noticed that BigQuery costs are spiraling out of control because analysts are running SELECT * queries on petabyte-scale tables. Which THREE strategies should you implement to optimize BigQuery costs? (Select THREE)
Answer options:
Implement table partitioning based on a date/time column.
Switch the BigQuery billing model from On-Demand to Flat-Rate (Capacity Pricing) and buy exactly 100 slots.
Implement table clustering on frequently filtered columns.
Export the data to Cloud Storage and use Dataproc to run the queries instead.
Enforce maximum bytes billed limits at the project and user level.
Compress the data using gzip before loading it into BigQuery.
50 questions · hints · full answers · grading