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)
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.
How to approach this question
Full Answer
Common mistakes
Practice the full GCP Professional Cloud Architect Practice Exam 3
50 questions · hints · full answers · grading
Expert