Skip to content
PCA Practice
SQ71

A company wants to expose a BigQuery dataset to a partner for reading but ensure they can only see non-PII columns. Which combination is most appropriate?

  1. AAuthorized view with column-level security and data masking
  2. BShare the service account key
  3. CCreate a public dataset
  4. DExport to CSV and email it
Show answer

Answer: A

Authorized views combined with column-level security and policy tags that mask PII columns provide granular data sharing without exposing sensitive fields.

← SQ70Practice this topicSQ72 →