Your finance team wants to analyze Google Cloud costs using standard SQL and build custom dashboards in Looker Studio. They need granular, daily cost data including resource labels.

What is the MOST efficient way to provide this data to the finance team?

Answer options:

Export billing data manually to a CSV file every day and upload it to Cloud Storage.

Enable Cloud Billing export to BigQuery.

Use the Pricing Calculator to generate a daily estimate and email it to the finance team.

Grant the finance team the Billing Account Administrator role so they can view the reports in the Console.

How to approach this question

Identify the GCP service that allows SQL querying of billing data.

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. BigQuery supports standard SQL and integrates seamlessly with Looker Studio.

Common mistakes

Choosing manual CSV exports or relying only on the built-in Console reports when SQL analysis is required.

Question 04 All questions Question 06

Practice the full GCP Associate Cloud Engineer Practice Exam 4

50 questions · hints · full answers · grading

More questions from this exam

Q01You have recently joined a new team and need to set up a new Google Cloud project for a developme...Easy Q02Your company uses Google Workspace. You need to grant a new developer, Alice, the ability to view...Medium Q03You have created a new GCP project and want to deploy a Compute Engine instance. However, when yo...Medium Q04Your startup has a strict monthly cloud budget of $500. You want to be notified via email when yo...Easy Q06You have just installed the Google Cloud SDK on your local workstation. You need to authenticate,...Easy

View all 50 questions →