A company uses BigQuery flat-rate pricing with 1000 slots. During peak hours, queries are queued, but during off-peak, many slots are idle. What is the most cost-effective way to handle the idle slots?
Flex slots are short-term commitments that provide extra capacity when needed.
Why this answer
Option B is correct because flex slots allow short-term capacity additions during peak, avoiding idle costs. Option A wastes money on idle slots. Option C increases cost.
Option D may not be cheaper overall.