🔥 40% Off Crucial Exams Memberships — Deal ends today!

2 hours, 29 minutes remaining!
Crucial Exams

GCP Professional Data Engineer Practice Question

Your company operates a healthcare data marketplace built on BigQuery Analytics Hub. You must publish a daily Cloud Storage CSV containing admissions data to an external research partner. Compliance requires that the partner:

  • never receives direct access to the Cloud Storage objects,
  • can query the table only for rows where hospital_region = "EMEA",
  • cannot see the columns patient_ssn and patient_email. Which approach best meets all requirements while minimizing operational overhead?

  • Load the CSV into a native BigQuery table, create an authorized view that filters the EMEA rows, exclude the PII columns from the view, and share that view in an Analytics Hub listing; grant the partner bigquery.dataViewer on the dataset.

  • Publish the Cloud Storage bucket as an object listing in Analytics Hub and rely on dynamic data masking policies to hide the PII columns at query time; grant the partner storage.objectViewer on the bucket and analyticshub.subscriber.

  • Create a BigLake external table on the CSV, attach a row-level security policy restricting hospital_region = "EMEA", apply policy tags to mask patient_ssn and patient_email, and publish the table in an Analytics Hub listing; grant the partner the analyticshub.subscriber role only.

  • Copy the CSV into a separate project, partition the table by region, delete non-EMEA partitions, and send the partner a signed URL to the sanitized dataset each day.

GCP Professional Data Engineer
Preparing and using data for analysis
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