Answer-first summary for fast verification
Answer: Create a sink to BigQuery and provide BigQuery access to the billing department
The correct answer is **B** because billing data can be automatically exported to BigQuery, which offers an SQL interface for the billing department to query the data. This method allows for the export of daily usage and cost estimates automatically to a specified BigQuery dataset, enabling access to billing data directly from BigQuery. Options **A** and **C** are incorrect as they require manual exporting and loading of data to Cloud SQL. Option **D** is also incorrect since billing data does not export to Cloud SQL. For more details, refer to the GCP documentation on Cloud Billing Export to BigQuery.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your billing department has requested your assistance in monitoring expenditures for a specific billing account. They prefer using SQL queries for report generation to avoid learning new tools and require the most up-to-date data. Which export option would best meet their needs?
A
File Export with CSV and load to Cloud SQL, then provide Cloud SQL access to the billing department
B
Create a sink to BigQuery and provide BigQuery access to the billing department
C
File Export with JSON and load to Cloud SQL, then provide Cloud SQL access to the billing department
D
Create a sink to Cloud SQL and provide Cloud SQL access to the billing department
No comments yet.