Your finance team wants to perform complex SQL analysis on your GCP billing data to understand cost trends across multiple projects and labels over the past year.

What is the MOST efficient way to enable this analysis?

Answer options:

Download the monthly CSV invoices from the Billing Console and import them into Cloud SQL.

Enable Cloud Billing export to BigQuery.

Use the Cloud Billing API to extract data daily and store it in Cloud Storage.

View the Cost Table report in the GCP Console.

How to approach this question

Identify the GCP service best suited for large-scale SQL analytics and how billing data integrates with it.

Full Answer

B.Enable Cloud Billing export to BigQuery.✓ Correct

Enable Cloud Billing export to BigQuery.

Cloud Billing export to BigQuery enables you to export detailed billing data (such as usage, cost estimates, and pricing data) automatically throughout the day to a BigQuery dataset. This allows the finance team to use standard SQL to analyze the data.

Common mistakes

Choosing manual CSV exports, which do not scale and are not automated.

Question 04 All questions Question 06

Practice the full GCP Associate Cloud Engineer Practice Exam 2

50 questions · hints · full answers · grading

More questions from this exam

Q01Your company is migrating to Google Cloud and needs to establish a resource hierarchy. You have t...Easy Q02You are managing access to a GCP project. You need to grant 15 developers the ability to view Com...Medium Q03You have created a new GCP project using the Cloud Console. You want to deploy a Cloud Function u...Easy Q04Your startup has a strict monthly cloud budget of $500. You want to be notified immediately if yo...Easy Q06You have just installed the Google Cloud SDK on your local machine. You want to authenticate, set...Medium

View all 50 questions →