Answer-first summary for fast verification
Answer: Apply a user- or project-level custom query quota for BigQuery data warehouse., Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.
To control BigQuery costs, you should use the following methods: (1) Apply a user- or project-level custom query quota for BigQuery data warehouse (Option B). Quotas allow you to ensure that users or projects do not exceed specified usage limits, thus helping in cost control. (2) Change your BigQuery query model from on-demand to flat rate and apply the appropriate number of slots to each project (Option E). This can provide predictable costs and can be adjusted based on usage patterns.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company has implemented BigQuery as an enterprise data warehouse solution. Users from various business units frequently run queries against this data warehouse. However, you have observed that the costs associated with running these queries are exceptionally high, necessitating better cost control measures. What are two methods you can use to manage and control these BigQuery query costs effectively? (Choose two.)
A
Split the users from business units to multiple projects.
B
Apply a user- or project-level custom query quota for BigQuery data warehouse.
C
Create separate copies of your BigQuery data warehouse for each business unit.
D
Split your BigQuery data warehouse into multiple data warehouses for each business unit.
E
Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.
