Google Professional Data Engineer Question 263
Select 3Google Cloud PlatformYour team is running multiple BigQuery workloads, including ad-hoc queries, scheduled data transformations, and real-time dashboards. You are tasked with optimizing compute resources while ensuring that critical workloads have guaranteed capacity and that costs are controlled. How should you manage BigQuery reservations and workloads to meet these requirements?
- A
Create separate reservations for critical workloads and assign them higher priority.
- B
Use a flat-rate pricing model to eliminate the need for reservations.
- C
Define a default reservation for low-priority workloads and assign non-critical jobs to it.
- D
Use BigQuery slot commitments to purchase compute capacity and allocate it to reservations.
- E
Enable on-demand pricing for critical workloads to ensure they always have sufficient compute resources.
Show answer and explanation
Correct answers: A, C, D
Explanation
To optimize BigQuery workloads, you should use reservations to manage and prioritize compute capacity effectively. By creating separate reservations for critical workloads and using a default reservation for non-critical jobs, you ensure proper resource allocation and cost control. Additionally, purchasing slot commitments provides a cost-effective way to secure resources for reservations. Flat-rate pricing and on-demand pricing are less effective in scenarios requiring workload prioritization and guaranteed compute capacity.
- A. Correct.
Correct: Creating separate reservations for critical workloads ensures they have dedicated compute resources and are not starved by other workloads.
- B. Incorrect.
Incorrect: While flat-rate pricing can simplify cost management, it does not provide the ability to allocate or prioritize workloads, which is critical in this scenario.
- C. Correct.
Correct: Defining a default reservation for low-priority workloads ensures that non-critical jobs do not compete with critical workloads for reserved capacity.
- D. Correct.
Correct: Using BigQuery slot commitments allows you to purchase compute capacity at a discounted rate and allocate it effectively across reservations.
- E. Incorrect.
Incorrect: On-demand pricing lacks predictability and control over resource allocation, making it unsuitable for critical workloads that require guaranteed capacity.