Google Cloud Professional Data Engineer — Question 24

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

Answer options

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

Correct answer: B, D, E

Explanation

The correct answer options B, D, and E are focused on controlling access based on user roles, limiting API access to specific users, and organizing data across multiple tables to enforce access restrictions. Option A does not directly limit user access to information, option C pertains to data security rather than access control, and option F is more about monitoring than enforcing access policies.