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.
Analytics Hub lets a publisher create a data exchange and add listings that reference BigQuery datasets. When a subscriber accepts a listing, BigQuery automatically creates a read-only linked dataset in the subscriber's project; queries run there without copying data and stay current because the data remains in the publisher project. To hide the customer_email column, the publisher can expose an authorized view (or apply column-level security) inside the shared dataset. The franchisee only receives access to the view, so the sensitive column is never visible. Granting the franchisee group the analyticshub.subscriber role on the exchange lets them subscribe to the listing. The other options copy data out of the publisher project or rely on manual transfers, which break the publisher-subscriber pattern and increase operational overhead.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Analytics Hub?
Open an interactive chat with Bash
What is an authorized view in BigQuery?
Open an interactive chat with Bash
How does the publisher-subscriber model work in Analytics Hub?
Open an interactive chat with Bash
What is Analytics Hub?
Open an interactive chat with Bash
What is an authorized view in BigQuery?
Open an interactive chat with Bash
How does column-level security work in BigQuery?
Open an interactive chat with Bash
GCP Professional Data Engineer
Preparing and using data for analysis
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .