A cloud engineering team needs to configure a standard daily Cloud Billing data export into BigQuery for central cost governance and multi-project SQL analysis. Which of the following operational requirements and configuration steps must be fulfilled to successfully enable this export? (Select TWO correct answers.)
- Create a destination BigQuery dataset, ensuring that the user configuring the export holds sufficient IAM permissions on both the Cloud Billing account and the target project dataset.Answer
- BAssign the Project Owner role on the destination project, which automatically grants administrative access to configure export sinks on the linked Cloud Billing account.
- Enable the BigQuery API within the target Google Cloud project that hosts the destination dataset.Answer
- DConfigure automated cost-capping rules within the BigQuery billing export settings to shut down compute workloads if daily export metrics exceed predefined thresholds.
Answer
To configure a standard Cloud Billing export to BigQuery, you must create a target BigQuery dataset with the required IAM roles on both the billing account and the target dataset, and ensure the BigQuery API is enabled in the host project.
Configuring a BigQuery billing export requires creating a destination dataset in a project with the BigQuery API enabled, as well as having appropriate IAM roles on both the billing account and the destination dataset. Project permissions alone do not grant rights on the billing account.
Step-by-Step Solution
Key Concept
Configuring Cloud Billing BigQuery Exports requires distinct IAM permissions on both the Cloud Billing Account and the target BigQuery dataset project, as well as enabling the BigQuery API.