Examtopics

Professional Cloud Architect
  • 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.


    ใ‚ทใƒฃใƒƒใƒ•ใƒซใƒขใƒผใƒ‰