Crucial Exams

GCP Professional Cloud Security Engineer Practice Question

Your company stores customer transactions in a BigQuery table that includes names, email addresses, and transaction amounts. An external analytics partner should query only a daily summary that contains total sales per country. They must not see any raw rows or PII and need interactive access through BigQuery, with minimal ongoing maintenance. Which solution satisfies these requirements?

  • Create a view in a separate dataset that aggregates sales by country, authorize the view on the source dataset, and grant the partner the BigQuery Data Viewer role on the dataset that contains the view only.

  • Grant the partner the BigQuery Data Viewer role on the source dataset and apply column-level security tags to hide PII columns.

  • Schedule a Dataflow pipeline that writes the daily country-level totals to Cloud Storage and share the objects with the partner using Signed URLs.

  • Attach a row-level security policy to the transactions table to exclude PII fields and grant the partner the BigQuery JobUser role on the dataset.

GCP Professional Cloud Security Engineer
Ensuring data protection
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