Google Cloud Professional Data Engineer PDE — Topic 1 Question 340

Question

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

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Implement column-level security policies in BigQuery tables with IAM permissions. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Cloud IAM grants fine-grained, least-privilege access to Google Cloud resources.

Google Cloud Professional Data Engineer PDE — Question 340