Professional Data Engineer

By Google · Question Mode

QuestionQ23

Preparing and using data for analysis

You are defining a data-governance strategy for a new BigQuery table containing medical and financial data. You need a scalable solution that lets clinical researchers access patient medical data without financial information, while allowing the accounting team access to only financial data with minimal patient identifiers. What should you do?

Explanation

BigQuery column-level access control restricts access to individual fields through policy tags and IAM permissions. Applying separate tags to medical, financial, and identifier columns lets each group receive access only to the columns it needs, enforcing least privilege without duplicating the table.

Learn more

Community Discussion

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