Answer-first summary for fast verification
Answer: 1. Create a Cloud Logging sink to export BigQuery data access logs to BigQuery. 2. Perform a BigQuery query on the generated table to extract the information you need.
The correct answer is B. Exporting BigQuery data access logs to BigQuery allows you to analyze queries in real-time, which helps you identify the most costly queries and which users are responsible for them. Option A is not feasible because the Billing page does not provide real-time query-level details. Option C is unnecessarily complex and involves additional steps that are not required for this task. Option D is useful for a broad overview but does not provide the timely granularity needed for real-time monitoring and analysis of individual queries and users.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your company uses BigQuery on Google Cloud for data warehousing on a pay-per-use basis. Managing costs and optimizing resource usage are important to you. Specifically, you need to monitor queries in real-time to identify which queries are the most costly and determine which users are generating the highest costs. What should you do?
A
B
C
D