Google Cloud Professional Data Engineer — Question 226

You are running your BigQuery project in the on-demand billing model and 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 then performs a merge into a 10 TB target table. This process is very scan intensive and you want to explore options to enable a predictable cost model. You need to create a BigQuery reservation based on utilization information gathered from BigQuery Monitoring and apply the reservation to the CDC process. What should you do?

Answer options

• A. Create a BigQuery reservation for the dataset.
• B. Create a BigQuery reservation for the job.
• C. Create a BigQuery reservation for the service account running the job.
• D. Create a BigQuery reservation for the project.

Correct answer: D

Explanation

Creating a BigQuery reservation for the project (Option D) is the correct choice because it allows you to allocate resources across all jobs in the project, providing a predictable cost model for your CDC process. Options A, B, and C limit the reservation scope to a dataset, a specific job, or a service account, which wouldn't provide the necessary coverage for the entire CDC operation.