Answer-first summary for fast verification
Answer: Create a BigQuery reservation for the project.
The correct option is D. BigQuery reservations can be applied at the project level, not at lower levels such as datasets or individual jobs. By creating a reservation for the project, you ensure that all jobs within the project can utilize the reserved slots, which helps in maintaining a predictable cost model. This is also highlighted in the official documentation and community discussions. Creating a reservation for the project ensures that the CDC process and any other jobs running in the project can use the reserved slot capacity, thereby optimizing cost and performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In your BigQuery project, currently operating under the on-demand billing model, you are executing a Change Data Capture (CDC) process for data ingestion. This CDC process involves loading 1 GB of data every 10 minutes into a temporary table, followed by merging this data into a target table that is 10 TB in size. Given the scan-intensive nature of this process, you seek to establish a predictable cost model. To achieve this, you need to create a BigQuery reservation based on utilization metrics obtained from BigQuery Monitoring and subsequently apply the reservation to your CDC process. What actions should you take?
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.
No comments yet.