nerdexam
Google

CLOUD-DIGITAL-LEADER · Question #36

Your team is using BigQuery as your central data warehouse. You are running a certain workload that you've run frequently over the last few days. It is a short, high capacity ana-lytics workload…

The correct answer is C. Flex Slots. Flex Slots allow you to purchase BigQuery compute capacity (slots) for a minimum of 60 seconds, making them ideal for short bursts of high-capacity analytics. You buy slots on-demand, run your heavy workload, then release them - paying only for the time used. On-demand pricing…

BigQuery Pricing and Resource Management

Question

Your team is using BigQuery as your central data warehouse. You are running a certain workload that you've run frequently over the last few days. It is a short, high capacity ana-lytics workload. Which of the following would be an appropriate pricing model to use?

Options

  • AThere is no need for any pricing model the first 1 TB of query data processed per month is free.
  • BOn-demand pricing
  • CFlex Slots
  • DFlat-rate reservations

How the community answered

(61 responses)
  • A
    15% (9)
  • B
    7% (4)
  • C
    74% (45)
  • D
    5% (3)

Explanation

Flex Slots allow you to purchase BigQuery compute capacity (slots) for a minimum of 60 seconds, making them ideal for short bursts of high-capacity analytics. You buy slots on-demand, run your heavy workload, then release them - paying only for the time used. On-demand pricing (B) charges per TB of data scanned and is cost-effective for sporadic, unpredictable queries but can become expensive for high-capacity repeated runs. Flat-rate reservations (D) require monthly or annual commitments, which is better for sustained, predictable workloads - not short bursts. The 1 TB free tier (A) is irrelevant for a 'high capacity' workload. Flex Slots strike the right balance of flexibility and cost-efficiency for this pattern.

Topics

#BigQuery Pricing#Flex Slots#Data Warehousing#Cost Optimization

Community Discussion

No community discussion yet for this question.

Full CLOUD-DIGITAL-LEADER Practice