ExpertEasy1 markMultiple Choice
Domain 5: Managing Implementation and Ensuring ReliabilityDomain 5Cost ManagementCloud BillingBigQuery
GCP PCA · Question 30 · Domain 5: Managing Implementation and Ensuring Reliability
The CFO of your company wants to create custom dashboards to analyze Google Cloud spending across different departments. They want to write SQL queries to find out exactly how much the 'Marketing' department spent on BigQuery last month. How should you configure the billing data to enable this?
The CFO of your company wants to create custom dashboards to analyze Google Cloud spending across different departments. They want to write SQL queries to find out exactly how much the 'Marketing' department spent on BigQuery last month. How should you configure the billing data to enable this?
Answer options:
A.
Download the monthly PDF invoice and use a Python script to parse it.
B.
Use the Cloud Billing API to pull data into a local MySQL database.
C.
Enable Cloud Billing export to BigQuery.
D.
Grant the CFO the roles/billing.viewer role so they can view the reports in the Cloud Console.
How to approach this question
Look for 'analyze billing data' + 'SQL queries'. BigQuery is the destination for billing exports.
Full Answer
C.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 is the foundational step for any FinOps practice, allowing teams to use SQL or BI tools to analyze costs by project, service, or custom labels.
Common mistakes
Relying only on the Cloud Console (D). The console is limited. For deep, custom analysis, exporting to BigQuery is required.
Practice the full GCP Professional Cloud Architect Practice Exam 3
50 questions · hints · full answers · grading
More questions from this exam
Q01**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...MediumQ02**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...HardQ03**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...MediumQ04**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...EasyQ05**CASE STUDY: TechStream Gaming**
**Company Overview:**
TechStream Gaming is a global gaming com...Medium