QuestionQ69

VerifiedData Management

Your organization stores highly sensitive data across multiple BigQuery datasets, and that data is updated once per day. You need to give a new data analyst access to query specific BigQuery data while preventing access to sensitive data. What should you do?

Explanation

The BigQuery Job User role grants permission to create query jobs in the project, while BigQuery Data Viewer granted only on a dedicated dataset limits readable data to that dataset. A materialized view that exposes only the permitted data must be configured as an authorized view when the analyst is not granted access to its base tables; this lets the view access source data without granting the analyst direct source-table access.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!