Google Cloud Associate Data Practitioner — Question 32

Your organization has several datasets in their data warehouse in BigQuery. Several analyst teams in different departments use the datasets to run queries. Your organization is concerned about the variability of their monthly BigQuery costs. You need to identify a solution that creates a fixed budget for costs associated with the queries run by each department. What should you do?

Answer options

• A. Create a custom quota for each analyst in BigQuery.
• B. Create a single reservation by using BigQuery editions. Assign all analysts to the reservation.
• C. Assign each analyst to a separate project associated with their department. Create a single reservation by using BigQuery editions. Assign all projects to the reservation.
• D. Assign each analyst to a separate project associated with their department. Create a single reservation for each department by using BigQuery editions. Create assignments for each project in the appropriate reservation.

Correct answer: D

Explanation

The correct answer is D because it allows for separate reservations for each department, ensuring that costs are managed effectively while allowing each department to have its budget. Options A and B do not provide the necessary budget control per department. Option C, while it creates a project for each analyst, fails to allocate distinct reservations for departmental budgeting.