Topic 1 Question 65
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 data. You want to share the data while following Google-recommended practices. What should you do?
Use Analytics Hub to create a listing on a private data exchange for each partner dataset. Allow each partner to subscribe to their respective listings.
Create 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.
Export the BigQuery data to a Cloud Storage bucket. Grant the partners the storage.objectUser IAM role on the bucket.
Grant the partners the bigquery.user IAM role on the BigQuery project.
ユーザの投票
コメント(1)
- 正解だと思う選択肢: A
The best option is A. Use Analytics Hub. Option A is best because Analytics Hub is Google's recommended, secure, and efficient way to share BigQuery datasets externally for querying in place. Option B (Dataflow & Pub/Sub) is incorrect because it's complex and inefficient for data sharing, Pub/Sub is for messaging. Option C (Cloud Storage Export) is incorrect because it requires copying data, not in-place querying. Option D (Project-level IAM) is incorrect because it's too broad access, not isolated per partner. Therefore, Option A, Analytics Hub, is the optimal solution for secure, efficient, and controlled external BigQuery data sharing.
👍 1n21837128472025/03/05
シャッフルモード