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

21 minutes, 39 seconds remaining!

GCP Professional Data Engineer Practice Question

You lead the data platform team for a retail group that wants to give several external franchisees access to a BigQuery dataset that contains daily sales. The franchisees must be able to run queries in their own GCP projects without replicating data, but they must never see the customer_email column. In addition, the franchisees expect the dataset to stay in sync as new rows arrive. Which approach satisfies these requirements while following the Analytics Hub publisher-subscriber model?

  • Deploy a Cloud Function that copies the sales table into each franchisee project every hour and drops the customer_email column during the copy.

  • Create a private data exchange in Analytics Hub, add a listing that points to a dataset containing an authorized view that excludes customer_email, and grant the franchisee group the analyticshub.subscriber role so they receive a linked dataset that stays current.

  • Schedule a daily export of the sales table to Cloud Storage, give the franchisees Storage Object Viewer access, and instruct them to create external tables pointing at the exported files.

  • Use BigQuery Data Transfer Service to replicate the sales dataset into each franchisee project and attach a policy tag that masks the customer_email column in every copy.

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.

Bash, the Crucial Exams Chat Bot
AI Bot