Google Cloud Associate Cloud Engineer — Question 101

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.)

Answer options

• 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.

Correct answer: B, E

Explanation

The correct answers are B and E because applying a user- or project-level custom query quota helps manage and limit costs by controlling how much data each user can query. Changing the query model to flat rate and assigning slots can also reduce costs by providing a predictable billing structure, avoiding unexpected charges from on-demand queries. The other options either do not effectively limit costs or unnecessarily complicate the data architecture.