Crucial Exams

GCP Professional Data Engineer Practice Question

Your SaaS platform stores all customer telemetry in a central BigQuery table. Requirements:

  1. Support engineers must see only the rows for the customer account they are assigned (account_id).
  2. Data scientists need unrestricted access to non-PII columns for all customers.
  3. PII columns (email, phone) must be visible only to the compliance team.
  4. You want to avoid data duplication and the operational overhead of hundreds of authorized views.

Which design best meets these constraints while following Google-recommended data governance practices?

  • Store each customer's data in a separate table inside its own dataset; give support engineers access to their customer's dataset, and let data scientists query a UNION ALL authorized view across all datasets while PII remains in the underlying tables.

  • Partition the telemetry table by account_id and grant each support engineer a dataset-level role scoped to the relevant partition; mask PII columns with scheduled queries that overwrite the table each night.

  • Keep a single telemetry table; create a row-level security policy filtering on account_id for the support-engineer group, and apply Data Catalog policy tags to PII columns so that only the compliance group can read those columns. Grant full table access to data scientists.

  • Maintain two telemetry tables: one complete table in a restricted dataset for compliance and a second table with PII columns removed for general users; synchronize the tables with a daily Dataflow job.

GCP Professional Data Engineer
Designing data processing systems
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot