QuestionQ116

VerifiedMaintaining and automating data workloads

You run your BigQuery project using the on-demand billing model and execute a change data capture (CDC) process that ingests data. The CDC process loads 1 GB of data every 10 minutes into a temporary table, then performs a merge into a 10 TB target table. This process is highly scan-intensive, and you want to investigate options that provide a predictable cost model.

You need to create a BigQuery reservation using utilization information collected from BigQuery Monitoring and apply the reservation to the CDC process. What should you do?

Explanation

BigQuery reservations provide dedicated slot capacity for predictable compute costs. A reservation assignment links a project, folder, or organization to the reservation, and query jobs submitted by an assigned project use that reservation’s slots. Assigning the CDC workload’s project is therefore the appropriate scope.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!