Associate Data Practitioner

By Google · Question Mode

QuestionQ32

Data Management

Your organization maintains several datasets in a BigQuery data warehouse. Multiple analyst teams across different departments query these datasets. The organization is concerned about variation in its monthly BigQuery costs.

You need to identify a solution that establishes a fixed budget for costs associated with the queries each department runs. What should you do?

Explanation

BigQuery Editions reservations use capacity-based pricing, with a configurable slot budget for each reservation. Assigning each department’s query projects to its own reservation isolates that department’s query workload and its available capacity, making departmental query costs predictable. A reservation assignment connects the projects that submit jobs to the appropriate reservation.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!