Scenario: You are running a BigQuery project using gcp video
data-engineer-pro video for scenario: You are running a BigQuery project using the on-demand billing model, and you are executing a change data capture (CDC)
Full Certification Question
Scenario: You are running a BigQuery project using the on-demand billing model, and you are executing a change data capture (CDC) process that ingests data. The CDC process loads 1 GB of data every 10 minutes into a temporary table and performs a merge into a 10 TB target table. This process is resource-intensive and involves significant scanning. You want to explore options to implement a predictable cost model. You need to create a BigQuery reservation based on usage data gathered from BigQuery Monitoring and apply the reservation to the CDC process. Question: What should you do to create a BigQuery reservation that applies to the CDC process and ensures predictable costs?