Help with the following question

 

Your organization needs to grant users access to query datasets in BigQuery but prevent them from accidentally deleting the datasets. You want a solution that follows Google-recommended practices. What should you do?

  • A. Add users to roles/bigquery user role only, instead of roles/bigquery dataOwner.
  • B. Add users to roles/bigquery dataEditor role only, instead of roles/bigquery dataOwner.
  • C. Create a custom role by removing delete permissions, and add users to that role only.
  • D. Create a custom role by removing delete permissions. Add users to the group, and then add the group to the custom role.
0 1 150
1 REPLY 1

kc3
Silver 4
Silver 4

I believe the answer to this question is D. 

Personally, I find the IAM roles sometimes not very intuitive. In this case, "User" is not the right role. See

https://cloud.google.com/bigquery/docs/running-queries

It is best practice to not assign users to roles directly, but to assign groups to roles, and users to those groups. 

Top Labels in this Space