Google Professional Data Engineer
Get started today
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?
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?
Exam-Like