PROFESSIONAL-CLOUD-ARCHITECT · Question #144
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?
The correct answer is D. Use Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query operation to. Cloud Audit Logs maintains audit logs for admin activity, data access and system events. BIGQUERY is automatically send to cloud audit log functionality. In the filter you can filter relevant BigQuery Audit messages, you can express filters as part of the…
Question
Options
- AConnect Google Data Studio to BigQuery. Create a dimension for the users and a metric for the
- BIn the BigQuery interface, execute a query on the JOBS table to get the required information.
- CUse
bq show' to list all jobs. Per job, usebq Is' to list job information and get the required - DUse Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query operation to
How the community answered
(33 responses)- A3% (1)
- C3% (1)
- D94% (31)
Explanation
Cloud Audit Logs maintains audit logs for admin activity, data access and system events. BIGQUERY is automatically send to cloud audit log functionality. In the filter you can filter relevant BigQuery Audit messages, you can express filters as part of the https://cloud.google.com/logging/docs/audit https://cloud.google.com/bigquery/docs/reference/auditlogs#ids https://cloud.google.com/bigquery/docs/reference/auditlogs#auditdata_examples
Topics
Community Discussion
No community discussion yet for this question.