Google Exam Associate Data Practitioner Topic 2 Question 14 Discussion

Actual exam question for Google's Associate Data Practitioner exam

Question #: 14
Topic #: 2

[All Associate Data Practitioner Questions]

Your organization has several datasets in BigQuery. The datasets need to be shared with your external partners so that they can run SQL queries without needing to copy the data to their own projects. You have organized each partner's data in its own BigQuery dataset. Each partner should be able to access only their dat

a. You want to share the data while following Google-recommended practices. What should you do?

AUse Analytics Hub to create a listing on a private data exchange for each partner dataset. Allow each partner to subscribe to their respective listings.

BCreate a Dataflow job that reads from each BigQuery dataset and pushes the data into a dedicated Pub/Sub topic for each partner. Grant each partner the pubsub. subscriber IAM role.

CExport the BigQuery data to a Cloud Storage bucket. Grant the partners the storage.objectUser IAM role on the bucket.

DGrant the partners the bigquery.user IAM role on the BigQuery project.

Show Suggested Answer

Suggested Answer: A

Using Analytics Hub to create a listing on a private data exchange for each partner dataset is the Google-recommended practice for securely sharing BigQuery data with external partners. Analytics Hub allows you to manage data sharing at scale, enabling partners to query datasets directly without needing to copy the data into their own projects. By creating separate listings for each partner dataset and allowing only the respective partner to subscribe, you ensure that partners can access only their specific data, adhering to the principle of least privilege. This approach is secure, efficient, and designed for scenarios involving external data sharing.

by Sabra at Jul 14, 2025, 01:31 AM

Limited Time Offer

25%

8 days ago

Option A seems like the best approach. Using Analytics Hub keeps the data secure and lets each partner access only their own data.

upvoted 0 times

...