Examkin

Question

Difficulty: MediumCreating Billing Budgets, Alerts, and BigQuery Exports

An organization manages several Google Cloud projects linked to a single central Cloud Billing account. To perform historical spend analysis using SQL, the lead engineer creates a dedicated project named `corp-billing-analytics` intended to host the billing dataset. The engineer needs to configure a detailed daily Cloud Billing export to BigQuery while following the principle of least privilege.

Which configuration strategy correctly enables the Cloud Billing export to the target dataset?

  1. Enable the BigQuery API in `corp-billing-analytics`, create a dataset in `corp-billing-analytics`, and ensure the configuring user holds both the Billing Account Costs Manager role on the Cloud Billing account and BigQuery Data Editor access on the destination project/dataset.Answer
  2. B
    Enable the Cloud Billing API on the organization root node instead of `corp-billing-analytics`, then set up an automated budget threshold rule to automatically disable export generation if project charges exceed $0.
  3. C
    Grant the configuring user the Project Owner role on `corp-billing-analytics`, which automatically grants implicit administrative access to link exports across any Cloud Billing account without requiring separate billing account IAM roles.
  4. D
    Configure a Cloud Billing budget alert rule that automatically caps and terminates BigQuery export ingestion whenever total monthly spending exceeds 100% of the defined target budget.

Answer

Enable the BigQuery API in `corp-billing-analytics`, create a dataset in `corp-billing-analytics`, and ensure the configuring user holds both the Billing Account Costs Manager role on the Cloud Billing account and BigQuery Data Editor access on the destination project/dataset.
The correct strategy requires enabling the BigQuery API within the destination project `corp-billing-analytics` and creating a target dataset. Because Cloud Billing export spans both the billing account and the target project, the user setting up the export must hold a billing role (Billing Account Costs Manager or Billing Account Administrator) on the billing account, and dataset write access (BigQuery Data Editor or Admin) in the destination project.

Step-by-Step Solution

1
Identify API and dataset hosting requirements
The BigQuery API must be enabled inside the destination project `corp-billing-analytics`, and a BigQuery dataset must be created to receive the export records.
Cloud Billing export streams daily cost estimates directly into a user-specified BigQuery dataset within a target project.
2
Determine IAM permissions across both resource boundaries
The engineer requires Billing Account Costs Manager (or Billing Account Administrator) on the billing account, as well as BigQuery Data Editor (or BigQuery Admin) on the target project/dataset.
Setting up exports crosses two IAM permission domains: reading billing metadata from the Cloud Billing Account and writing tables into the BigQuery dataset.

Key Concept

Cloud Billing BigQuery Export Requirements and Dual-Boundary IAM Permissions
Rate this question

Topics

Creating Billing Budgets, Alerts, and BigQuery Exports

More questions from this topic