Your company is in a highly regulated industry. One of your requirements is to ensure individual users have access only to the minimum amount of information required to do their jobs. You want to enforce this requirement with Google BigQuery. Which three approaches can you take? (Choose three.)
A. Disable writes to certain tables.
B. Restrict access to tables by role.
C. Ensure that the data is encrypted at all times.
D. Restrict BigQuery API access to approved users.
E. Segregate data across multiple tables or databases.
F. Use Google Stackdriver Audit Logging to determine policy violations.
I think the correct answers are CDE
A is incorrect in its concerning data integrity while the question is about access to information (read and write)
B is incorrect because BigQuery does not support access control on table level. See https://cloud.google.com/bigquery/docs/dataset-access-controls
F is incorrect because it is detecting violations while the question asks for enforcing controls.
Yes should be ADF: https://cloud.google.com/bigquery/docs/dataset-access-controls
Should it be A D F??
Is A, C and F, you can not restrict by table or partition.
Data is encrypted no matter what, dont need to do anything there.
segregating data across tables or databases wont do, everything has to do with datasets.