nerdexam
Google

ASSOCIATE-CLOUD-ENGINEER · Question #51

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 s

The correct answer is D. Export your bill to a BigQuery dataset, and then write time window-based SQL queries for. BigQuery provides an ideal storage option to store and query in standard SQL dialect.BigQuery, Google's serverless, highly scalable enterprise data warehouse.

Submitted by tyler.j· Mar 30, 2026Ensuring successful operation of a cloud solution

Question

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?

Options

  • AExport your bill to a Cloud Storage bucket, and then import into Cloud Bigtable for analysis.
  • BExport your bill to a Cloud Storage bucket, and then import into Google Sheets for analysis.
  • CExport your transactions to a local file, and perform analysis with a desktop tool.
  • DExport your bill to a BigQuery dataset, and then write time window-based SQL queries for

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    8% (3)
  • C
    3% (1)
  • D
    87% (33)

Explanation

BigQuery provides an ideal storage option to store and query in standard SQL dialect.BigQuery, Google's serverless, highly scalable enterprise data warehouse.

Topics

#billing export#BigQuery#cost analysis#SQL

Community Discussion

No community discussion yet for this question.

Full ASSOCIATE-CLOUD-ENGINEER Practice