ExpertMedium1 markMultiple Choice
GCP ACE · Question 05 · Domain 1.2: Managing billing configuration
You need to analyze your GCP billing data using complex SQL queries to understand cost trends across multiple projects and labels. What is the MOST efficient approach?
You need to analyze your GCP billing data using complex SQL queries to understand cost trends across multiple projects and labels. What is the MOST efficient approach?
Answer options:
A.
Download the billing invoice as a CSV and use a local spreadsheet application.
B.
Use the Cost Table report in the Cloud Console.
C.
Enable Cloud Billing export to BigQuery and run queries there.
D.
Export billing data to Cloud Storage and use Cloud Functions to parse it.
How to approach this question
Match the requirement for 'complex SQL queries' with GCP's data warehouse service.
Full Answer
C.Enable Cloud Billing export to BigQuery and run queries there.✓ Correct
Enable Cloud Billing export to BigQuery and run queries there.
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. You can then use standard SQL to analyze the data.
Common mistakes
Choosing CSV download, which doesn't scale for complex, automated analysis.
Practice the full GCP Associate Cloud Engineer Practice Exam 1
50 questions · hints · full answers · grading
More questions from this exam
Q01What is the highest level of the Google Cloud resource hierarchy?EasyQ02You need to enable the Compute Engine API in a new project using the command line. Which command ...EasyQ03You are setting up a new GCP environment. You need to grant a group of developers access to view ...MediumQ04You want to receive an email notification when your GCP spending exceeds $1000 this month. What s...EasyQ06You have just installed the Google Cloud SDK on your local machine. Which command should you run ...Easy