Answer-first summary for fast verification
Answer: Export the billing account data to BigQuery, then use BigQuery to analyze the service data for the specified projects by day and month.
The correct approach is to export the billing data to BigQuery for analyzing daily and monthly spending across services. This method is both efficient and flexible. BigQuery allows for the automatic export of daily usage and cost estimates to a specified dataset, enabling easy access to billing data. While exporting to a JSON file or importing into a SQL database are possible, they are less straightforward and adaptable. Built-in reports do not provide the detailed analysis required for this scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your finance team is collaborating with the engineering team to analyze daily and monthly spending across all projects under a billing account. What is the most straightforward and adaptable method to aggregate and examine this data?
A
Import the billing data into a SQL database from files, then utilize BigQuery to analyze the service data for the specified projects by day and month.
B
Leverage the built-in reports that inherently display this data.
C
Export the billing account data to a JSON file, employ a Cloud Function to detect new files in a Storage bucket, and program the function to analyze the service data for the desired projects by day and month.
D
Export the billing account data to BigQuery, then use BigQuery to analyze the service data for the specified projects by day and month.