Your BigQuery project has several users. For audit purposes, you need to see how many queries each user ran in the last month. What should you do?
Choose an answer
Tap an option to check your answer.
Correct answer: In the BigQuery interface, execute a query on the JOBS table to get the required information..
Why this is the answer
The correct approach is to query the BigQuery JOBS table. BigQuery automatically logs job metadata, including user and query details, to the INFORMATIONSCHEMA.JOBS view (or INFORMATIONSCHEMA.JOBS for older projects). You can directly query this table within the BigQuery interface to filter by user and time range to count queries. Connecting Data Studio to BigQuery would allow visualization, but the initial data extraction still requires querying BigQuery, making it an indirect solution for the core task. Using bq show and bq ls are command-line tools for individual job inspection, not efficient for aggregating data across all jobs for all users over a month. Cloud Audit Logging captures audit events, but the JOBS table provides a more direct and structured way to access BigQuery-specific job execution details, including query text and user, making it more suitable for this specific use case.
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