Answer-first summary for fast verification
Answer: Use Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query operation to get the required information.
The correct answer is D. Cloud Audit Logging records activities and API calls in Google Cloud services, including BigQuery. By using Cloud Audit Logging, you can filter the logs to focus on query operations and obtain detailed information about how many queries each user has run in the last month. This method provides a comprehensive and reliable way to perform audits, as highlighted by several expert opinions and documentation references.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are managing a BigQuery project with several users and need to perform an audit to determine how many queries each user executed in the past month. Considering auditing best practices and available tools in Google Cloud, what is the best way to obtain this information?
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.
No comments yet.