Topic 1 Question 264
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?
Create a BigQuery reservation for the dataset.
Create a BigQuery reservation for the job.
Create a BigQuery reservation for the service account running the job.
Create a BigQuery reservation for the project.
ユーザの投票
コメント(5)
- 正解だと思う選択肢: D
C or D ??
Option C (service account) allows you to target the reservation specifically to the CDC process or any other jobs run by that service account. This is particularly useful if you have multiple processes running in the project with different performance or cost requirements.
Option D (project) applies the reservation across all jobs in the project, which is a broader approach. If the CDC process is the primary or sole job running in the project and you want all jobs to share the same reservation, then this option might be more straightforward.
👍 2raaad2024/01/05 - 正解だと思う選択肢: D
D. Create a BigQuery reservation for the project.
👍 1scaenruy2024/01/04 D. Reservation is on project, folder or organisation level.
👍 1GCP0012024/01/08
シャッフルモード