Analyze service costs across three projects and produce daily and monthly service-type cost estimates for the next six months using standard SQL. What should you do?
Choose an answer
Tap an option to check your answer.
Correct answer: Export billing data to a BigQuery dataset, then run time-window SQL queries for analysis..
Why this is the answer
The most effective approach is to export billing data to a BigQuery dataset and then use time-window SQL queries. BigQuery is a fully managed, serverless data warehouse that excels at analyzing large datasets with SQL, making it ideal for cost analysis across multiple projects and generating time-based estimates. Exporting to Cloud Storage and then Cloud Bigtable is inefficient; Bigtable is a NoSQL database for high-throughput, low-latency operations, not analytical SQL queries. Exporting to Cloud Storage and then Google Sheets is unsuitable for large datasets and complex SQL analysis. Exporting to a local file and using a desktop tool lacks scalability, collaboration features, and the power to handle extensive billing data effectively.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed