hiexam
google · Professional-Data-Engineer · Q425 · multiple_response · topic_1

Your company is in a highly regulated industry. One of your requirements is to ensure individual users have access only…

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

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.