Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Your BigQuery project has multiple users. For auditing, you need to determine the number of queries executed by each user in the previous month. What is the correct approach?
A
Connect Google Data Studio to BigQuery. Create a dimension for the users and a metric for the amount of queries per user.
B
In the BigQuery interface, execute a query on the JOBS table to get the required information.
C
Use 'bq show' to list all jobs. Per job, use 'bq ls' to list job information and get the required information.
D
Use Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query operation to get the required information.