Topic 1 Question 83
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?
Connect Google Data Studio to BigQuery. Create a dimension for the users and a metric for the amount of queries per user.
In the BigQuery interface, execute a query on the JOBS table to get the required information.
Use 'bq show' to list all jobs. Per job, use 'bq ls' to list job information and get the required information.
Use Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query operation to get the required information.
ใฆใผใถใฎๆ็ฅจ
ใณใกใณใ(17)
D- reasons: 1.-Cloud Audit Logs maintains audit logs for admin activity, data access and system events. BIGQUERY is automatically send to cloud audit log functionality. 2.- In the filter you can filter relevant BigQuery Audit messages, you can express filters as part of the export
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
๐ 42Googler22020/04/12- ๐ 26Zarmi2020/05/04
The correct answer is D. Use Cloud Audit Logging to view Cloud Audit Logs, and create a filter on the query operation to get the required information.
Google Cloud's Cloud Audit Logging service allows you to view, search, and export audit logs for your Google Cloud projects. These audit logs contain information about the actions that are performed in your project, including queries that are run in BigQuery.
To see how many queries each user ran in the last month, you can use Cloud Audit Logging to view the Cloud Audit Logs for your BigQuery project. Then, you can create a filter on the query operation to see only the queries that were run. You can also create a filter on the user field to see the queries that were run by each user. This will allow you to see the number of queries that were run by each user in the last month, which can be useful for audit purposes.
๐ 3omermahgoub2022/12/22
ใทใฃใใใซใขใผใ