nerdexam
Google

ASSOCIATE-CLOUD-ENGINEER · Question #121

Your company implemented BigQuery as an enterprise data warehouse. Users from multiple business units run queries on this data warehouse. However, you notice that query costs for BigQuery are very hig

The correct answer is B. Apply a user- or project-level custom query quota for BigQuery data warehouse. E. Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of. First of all you can define quotas on project or user level and 2nd one is you can change from on demand to flat rate model and define the parameters based on your requirement. https://cloud.google.com/bigquery/docs/custom-quotas https://cloud.google.com/bigquery/pricing#flat_rat

Submitted by thandi_sa· Mar 30, 2026Planning and configuring a cloud solution

Question

Your company implemented BigQuery as an enterprise data warehouse. Users from multiple business units run queries on this data warehouse. However, you notice that query costs for BigQuery are very high, and you need to control costs. Which two methods should you use? (Choose two.)

Options

  • ASplit the users from business units to multiple projects.
  • BApply a user- or project-level custom query quota for BigQuery data warehouse.
  • CCreate separate copies of your BigQuery data warehouse for each business unit.
  • DSplit your BigQuery data warehouse into multiple data warehouses for each business unit.
  • EChange your BigQuery query model from on-demand to flat rate. Apply the appropriate number of

How the community answered

(17 responses)
  • A
    12% (2)
  • B
    71% (12)
  • C
    12% (2)
  • D
    6% (1)

Explanation

First of all you can define quotas on project or user level and 2nd one is you can change from on demand to flat rate model and define the parameters based on your requirement. https://cloud.google.com/bigquery/docs/custom-quotas https://cloud.google.com/bigquery/pricing#flat_rate_pricing

Topics

#BigQuery cost control#query quotas#flat rate pricing#on-demand pricing

Community Discussion

No community discussion yet for this question.

Full ASSOCIATE-CLOUD-ENGINEER Practice