Topic 1 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?
Create a custom quota for each analyst in BigQuery.
Create a single reservation by using BigQuery editions. Assign all analysts to the reservation.
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.
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.
ユーザの投票
コメント(1)
- 正解だと思う選択肢: D
The best solution for creating fixed BigQuery budgets per department is D. Separate projects per department, separate reservations per department, and project assignments to departmental reservations. This approach is optimal because separate reservations per department create fixed, predictable costs for each department. Assigning departmental projects to their respective reservations ensures that each department's query costs are contained within their allocated budget. Options A, B, and C fail to create fixed departmental budgets. Option A (Quotas) is for resource limits, not budgets. Options B and C (Single Reservation) provide overall cost predictability but don't enable departmental budget control. Therefore, Option D is the only option that effectively addresses the requirement of fixed departmental budgets.
👍 1n21837128472025/02/27
シャッフルモード