Your finance team wants to perform complex SQL queries on your Google Cloud billing data to analyze spending trends across multiple projects and custom labels. They need this data to be updated automatically every day.

How should you configure this?

Answer options:

Set up a daily budget alert that sends a Pub/Sub message to a Cloud Function, which writes to Cloud SQL.

Enable Cloud Billing export to BigQuery.

Export the billing data manually to a CSV file from the Cloud Console every day.

Use the Pricing Calculator to generate a daily report and save it to Cloud Storage.

How to approach this question

Identify the GCP service designed for analyzing large datasets with SQL (BigQuery) and the native billing feature that 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 Google Cloud billing data (such as usage, cost estimates, and pricing data) automatically throughout the day to a BigQuery dataset. This allows the finance team to run complex SQL queries and build dashboards.

Common mistakes

Confusing budget alerts with billing exports. Alerts are for notifications, exports are for data analysis.

Question 03 All questions Question 05

Practice the full GCP Associate Cloud Engineer Practice Exam 7

50 questions · hints · full answers · grading

More questions from this exam

Q01You are starting a new initiative and need to create a new Google Cloud project using the Cloud S...Easy Q02Your company is migrating to Google Cloud and wants to manage user identities centrally. They cur...Medium Q03You have just created a new Google Cloud project and want to deploy a containerized application u...Medium Q05You are managing a development project in Google Cloud. You want to ensure that you are notified ...Easy Q06You have just installed the Google Cloud SDK on your local workstation. You need to authenticate ...Easy

View all 50 questions →