Associate Data Practitioner

By Google · Question Mode

QuestionQ8

Data Management

You are a database administrator responsible for sales-transaction data by region in a BigQuery table. You must ensure that every sales representative can view only transactions from their own region. What should you do?

Explanation

BigQuery row-level access policies enforce filters on table rows for specified users or groups, such as a filter that permits a representative to see only rows for their assigned region. Policy tags and data masking control column access or presentation, while dataset-level IAM permissions do not filter individual table rows. Use row-level security

Learn more

Community Discussion

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