Answer-first summary for fast verification
Answer: Create a sink to BigQuery and provide BigQuery access to the billing department
The correct answer is to create a sink to BigQuery and provide BigQuery access to the billing department. This option allows billing data to be automatically exported to BigQuery, which provides an SQL interface for querying the data. This method supports the billing department's preference for SQL querying and ensures the data is as current as possible. Manual exporting and loading data to Cloud SQL, as suggested in options B and D, are less efficient. Option C is incorrect because billing data cannot be exported directly to Cloud SQL.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your billing department has requested assistance in tracking spending against a specific billing account. They prefer using SQL queries for report generation to avoid learning new tools and need the data to be as up-to-date as possible. Which export option would best meet their needs?
A
Create a sink to BigQuery and provide BigQuery access to the billing department
B
File Export with JSON and load to Cloud SQL, then provide Cloud SQL access to the billing department
C
Create a sink to Cloud SQL and provide Cloud SQL access to the billing department
D
File Export with CSV and load to Cloud SQL, then provide Cloud SQL access to the billing department
No comments yet.