Posted by: Pdfprep
Post Date: October 26, 2020
Your BigQuery project has several users. For audit purposes, you need to see how many queries each user ran in the last month.
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 Is’ 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.
Answer: C
Explanation:
Reference https://cloud.google.com/bigquery/docs/access-control
Leave a Reply