# Professional-Data-Engineer — Question 425

**Type:** multiple_response
**Topics:** topic_1

## Question

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.)

## Correct Answer

_See scenario._

## Explanation

correct option -> B. Restrict access to tables by role. 
Reference: https://cloud.google.com/bigquery/docs/table-access-controls-intro

correct option -> D. Restrict BigQuery API access to approved users. 
***Only approved users will have access which means other users will have minimum amount of information required to do their job.***
Reference: https://cloud.google.com/bigquery/docs/access-control

correct option -> F. Use Google Stackdriver Audit Logging to determine policy violations.
Reference: https://cloud.google.com/bigquery/docs/table-access-controls-intro#logging

A. Disable writes to certain tables. ---> Read is still available(not minimal access)
C. Ensure that the data is encrypted at all times. ---> Data is encrypted by default.
E. Segregate data across multiple tables or databases. ---> Normalization is of no help here.

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/google/Professional-Data-Engineer/425  
Practice (tracked): https://hiexam.net/study/Professional-Data-Engineer/practice