Examkin

Question

Difficulty: MediumCreating Billing Budgets, Alerts, and BigQuery Exports

A Cloud Engineer needs to set up a detailed daily Cloud Billing export to BigQuery for central cost governance. Place the steps required to configure and verify this billing export in the correct chronological order.

  1. 1Create a destination BigQuery dataset in the selected management project with an appropriate data location.
  2. 2Verify that the configuring identity possesses both the Billing Account Administrator role on the billing account and BigQuery Data Editor on the target dataset.
  3. 3Navigate to the Cloud Billing section in the Google Cloud Console, choose the target Billing Account, and select Billing export.
  4. 4Enable Detailed Cost Usage Export and specify the target Project ID and BigQuery Dataset ID.
  5. 5Verify table creation in the BigQuery console and execute queries against the populated cost export dataset.

Answer

The correct sequence starts with creating the BigQuery dataset, verifying requisite IAM permissions (Billing Account Administrator and BigQuery Data Editor), navigating to the Cloud Billing export settings in the GCP Console, specifying the target project and dataset to enable Detailed Cost Usage Export, and finally verifying table population in BigQuery.
Configuring BigQuery Cloud Billing exports follows a strict prerequisite workflow: a BigQuery dataset must exist first, proper administrative IAM permissions on both the billing account and dataset must be held, the export sink must be pointed to the project and dataset via the Cloud Billing Console, and data populates into automatically created partitioned tables for verification.

Step-by-Step Solution

1
Create the destination BigQuery dataset
A target dataset exists to receive billing export data.
Cloud Billing export requires an existing dataset before configuration can be saved.
2
Confirm IAM permissions
The identity holds Billing Account Administrator on the billing account and BigQuery Data Editor on the dataset.
Without proper roles on both the billing account and destination dataset, setting up the export sink will fail.
3
Navigate to Cloud Billing export settings
The Billing export management interface is open in the GCP Console.
Billing exports are managed directly within the Cloud Billing account settings.
4
Configure export details and save
The detailed usage cost export sink is activated pointing to the specified BigQuery dataset.
Explicitly selecting the project ID and dataset binds the billing sink to BigQuery.
5
Validate table population and query data
Exported tables appear in BigQuery containing resource usage records.
Verifying table generation ensures that automated daily data loading is operating correctly.

Key Concept

Cloud Billing BigQuery Export Configuration Sequence
Rate this question

Topics

Creating Billing Budgets, Alerts, and BigQuery Exports

More questions from this topic