ExpertGCP PCA · Question 47 · Cost Optimization
Your data analytics team uses BigQuery extensively. The CFO has noticed that BigQuery costs have tripled in the last two months. Upon investigation, you find that analysts are running SELECT * queries on massive, multi-terabyte tables. Which TWO actions should you take to optimize costs without stopping the analysts from doing their work? (Select TWO)
Your data analytics team uses BigQuery extensively. The CFO has noticed that BigQuery costs have tripled in the last two months. Upon investigation, you find that analysts are running SELECT * queries on massive, multi-terabyte tables. Which TWO actions should you take to optimize costs without stopping the analysts from doing their work? (Select TWO)
Answer options:
Revoke BigQuery access from the analysts.
Enforce a maximum bytes billed limit at the project or user level.
Switch BigQuery from on-demand pricing to flat-rate pricing immediately.
Implement table partitioning and clustering, and require a partition filter on queries.
Export the data to Cloud Storage and have analysts use Dataproc instead.
How to approach this question
Full Answer
Common mistakes
Practice the full GCP Professional Cloud Architect Practice Exam 7
50 questions · hints · full answers · grading