Exam Professional Data Engineer topic 1 question 264 discussion

Option D, reservation can't be applied to resources lower than projects (only to Org, folders or projects)

Reserve assignments To use the slot capacity you purchased, assign projects, folders, or organizations to a reservation. When a job in a project runs, it uses slots from the assigned reservation. Resources can inherit roles from their parents in the resource hierarchy. Even if a project is not assigned to a reservation, it inherits the assignment from the parent folder or organization, if any. If a project does not have an assigned or inherited reservation, the job uses on-demand pricing. For more information about the resource hierarchy, see Organizing BigQuery Resources .

Answer C provides the granularity you need. Answer D is for the entire project... however the question ONLY wants it for the CDC process - so service account is better. In BigQuery, reservations are assigned to "assignments", which can be: Project Folder Organization Service account

"When you create commitments and reservations, they are associated with a Google Cloud project." - https://cloud.google.com/bigquery/docs/reservations-intro#admin-project

https://cloud.google.com/bigquery/docs/reservations-intro#assignments

Option B provides a more granularity solution

The correct answer is B. Create a BigQuery reservation at the job level. Create a BigQuery reservation at the job level: This is the most suitable option. By creating a job-level reservation, you can allocate resources specifically to the CDC process and improve the accuracy of cost forecasting. Steps to create and apply a BigQuery reservation: Identify the job: Clearly identify the job that executes the CDC process. Create a reservation: Use the BigQuery console or API to create a reservation, specifying the job's label, query text, and other details. Apply the reservation: Assign the created reservation to the job that executes the CDC process.

Are these questions really useful andd coming in GDE Exam? Anyone appeared recently and passed ?

https://cloud.google.com/blog/products/data-analytics/manage-bigquery-costs-with-custom-quotas. Quotas can be applied on Project or User Level

D- choose the correct project and apply the task type background:https://cloud.google.com/bigquery/docs/reservations-intro?hl=fr#assignments

Option D

D. Reservation is on project, folder or organisation level.

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.

D. Create a BigQuery reservation for the project.