Google Professional Data Engineer Question 244
Select 2Google Cloud PlatformYour organization runs a BigQuery data warehouse and processes daily analytics workloads with predictable demand during business hours. However, your team occasionally needs to run ad-hoc, unpredictable queries during off-peak hours. You are tasked with optimizing the cost and performance of your BigQuery environment. Which combination of slot pricing models should you choose to meet these requirements?
- A
Commit to flat-rate slots for predictable workloads and use flex slots for ad-hoc queries.
- B
Commit to flat-rate slots for predictable workloads and use on-demand slots for ad-hoc queries.
- C
Use only on-demand slots for both predictable and ad-hoc workloads.
- D
Commit to flex slots only, as they provide cost-effective pricing for all workloads.
- E
Commit to flat-rate slots for predictable workloads and supplement with flex slots for ad-hoc queries.
Show answer and explanation
Correct answers: A, E
Explanation
To optimize cost and performance in BigQuery, predictable workloads should leverage flat-rate slots for their cost-efficiency with consistent demand. For ad-hoc or unpredictable queries, flex slots are a better choice than on-demand slots due to their lower cost and flexibility for temporary use. This combination ensures that both high-priority predictable workloads and occasional ad-hoc queries are efficiently managed without overspending.
- A. Correct.
Correct: Flat-rate slots are ideal for predictable workloads, and flex slots provide a cost-effective option for temporary or ad-hoc needs due to their short-term commitment flexibility.
- B. Incorrect.
Incorrect: While flat-rate slots work for predictable workloads, on-demand slots can become expensive for ad-hoc queries, especially if used frequently.
- C. Incorrect.
Incorrect: Using only on-demand slots for all workloads is not cost-efficient for predictable workloads, as flat-rate pricing offers better value for consistent usage.
- D. Incorrect.
Incorrect: Flex slots alone are not suitable for predictable workloads, as they are intended for short-term or temporary needs and lack the cost efficiency of flat-rate slots for steady demand.
- E. Correct.
Correct: Flat-rate slots are optimized for predictable workloads, and flex slots can be used to handle ad-hoc queries at a lower cost than on-demand slots due to their flexibility and short-term pricing.