Count how many queries each BigQuery user ran in the last month. Which approach provides this audit data?
Choose an answer
Tap an option to check your answer.
Correct answer: In the BigQuery UI, run a query against the JOBS table to count queries per user..
Why this is the answer
The BigQuery UI allows direct querying of the INFORMATIONSCHEMA.JOBS table (or bigquery-public-data:region.INFORMATIONSCHEMA.JOBS for cross-project access), which contains metadata about all jobs, including queries, run within a project. You can filter this table by creationtime and group by useremail to count queries per user for the last month. Cloud Audit Logs also record query operations, but querying the INFORMATIONSCHEMA.JOBS table directly within BigQuery is a more efficient and purpose-built method for this specific task, as it provides structured job metadata. 'bq show' and 'bq ls' are command-line tools for inspecting individual jobs or datasets, not for aggregating job statistics across all users. Data Studio is a visualization tool; while it can connect to BigQuery, it would still need the underlying data from INFORMATIONSCHEMA.JOBS or Audit Logs to be prepared first.
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