Your company has a Google Cloud project that uses BigQuery for data warehousing on a pay-per-use basis. You want to monitor queries in real time to discover the most costly queries and which users spend the most. What should you do?
Choose an answer
Tap an option to check your answer.
Correct answer: 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..
Why this is the answer
The correct answer is to create a Cloud Logging sink to export BigQuery data access logs to BigQuery and then query the generated table. BigQuery data access logs contain detailed information about each query, including the user who ran it and the amount of data processed, which directly correlates to cost in a pay-per-use model. Exporting these logs to BigQuery allows for powerful, real-time analysis using SQL. The other options are less effective: Adding labels to datasets and checking billing reports by user is not feasible for real-time, detailed query cost analysis per user, as billing reports are aggregated and not granular enough for individual queries. Exporting logs to Cloud Storage and using Dataflow is overly complex and introduces unnecessary latency and cost compared to directly querying the logs in BigQuery. Activating billing export to BigQuery provides aggregated billing data, not the granular, per-query details needed to identify specific costly queries and users in real time.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed