Skip to content
PCA Practice
SQ70

A data governance team needs to restrict access so that analysts in the EU can only see rows belonging to EU customers in a BigQuery table. Which feature enables this?

  1. ACreate separate tables per region
  2. BRow-level security policies in BigQuery
  3. CUse Cloud DLP to mask the table
  4. DColumn-level encryption only
Show answer

Answer: B

BigQuery row-level security policies filter rows based on the querying user's attributes, enabling data segmentation without duplicating tables. Column-level security hides columns, not rows.

← SQ69Practice this topicSQ71 →