Examkin

Question

Difficulty: MediumCreating Billing Budgets, Alerts, and BigQuery Exports

A Cloud Engineer needs to establish a daily Cloud Billing detailed usage cost export to BigQuery for organization-wide financial analytics. What is the correct sequence of steps to configure this export?

  1. 1Verify that the engineer has the Billing Account Costs Manager IAM role on the Cloud Billing account and BigQuery Data Editor IAM role on the target project.
  2. 2Enable the BigQuery API in the destination Google Cloud project.
  3. 3Create a destination BigQuery dataset in the target project to serve as the export sink.
  4. 4Open the Google Cloud Console, navigate to the Cloud Billing menu, and select Billing export.
  5. 5Enable Detailed usage cost export, select the destination project ID and target dataset, then save the configuration.

Answer

The correct sequence begins with verifying required IAM roles (Billing Account Costs Manager on the billing account and BigQuery Data Editor on the target project), followed by enabling the BigQuery API in the destination project, creating the target BigQuery dataset, navigating to the Billing export section in the Cloud Billing console, and finally configuring the Detailed usage cost export with the project ID and dataset name.
Configuring a BigQuery billing export requires completing prerequisite security and infrastructure tasks first. First, verify IAM roles on both the billing account (Billing Account Costs Manager) and project (BigQuery Data Editor). Second, enable the BigQuery API in the destination project. Third, create the target BigQuery dataset. Fourth, navigate to the Billing export section of the Cloud Billing console. Fifth, configure the Detailed usage cost export by entering the target project ID and dataset, then save.

Step-by-Step Solution

1
Grant and verify IAM roles
The engineer holds Billing Account Costs Manager and BigQuery Data Editor roles.
Without billing administrative access and project data editor access, dataset creation and billing sink creation will be denied.
2
Enable BigQuery API
BigQuery API is enabled in the destination project.
Services in GCP cannot be provisioned or configured until their corresponding API is activated in the project.
3
Create destination dataset
Target BigQuery dataset is created.
The export workflow requires selecting an existing dataset as the destination sink.
4
Access Cloud Billing export menu
Billing export settings interface is loaded.
Cloud Billing export sinks are managed within the Cloud Billing account settings.
5
Configure and save export sink
Detailed usage cost data starts exporting daily to BigQuery.
Specifying the project and dataset binds the billing stream to BigQuery.

Key Concept

Configuring BigQuery Billing Exports
Rate this question

Topics

Creating Billing Budgets, Alerts, and BigQuery Exports

More questions from this topic