Google Cloud Associate Cloud Engineer — Question 1

You are analyzing Google Cloud Platform service costs from three separate projects. You want to use this information to create service cost estimates by service type, daily and monthly, for the next six months using standard query syntax. What should you do?

Answer options

• A. Export your bill to a Cloud Storage bucket, and then import into Cloud Bigtable for analysis.
• B. Export your bill to a Cloud Storage bucket, and then import into Google Sheets for analysis.
• C. Export your transactions to a local file, and perform analysis with a desktop tool.
• D. Export your bill to a BigQuery dataset, and then write time window-based SQL queries for analysis.

Correct answer: D

Explanation

The correct answer is D because exporting the bill to a BigQuery dataset allows for powerful SQL queries that can handle large datasets and perform time-based analysis. Options A and B do not utilize the capabilities of BigQuery for advanced analysis, and option C limits the analysis to a local desktop tool, which may not be efficient for large amounts of data.