Google Cloud Associate Data Practitioner — Question 59

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?

Answer options

• A. 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.
• B. 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.
• C. Export the BigQuery data to a Cloud Storage bucket. Grant the partners the storage.objectUser IAM role on the bucket.
• D. Grant the partners the bigquery.user IAM role on the BigQuery project.

Correct answer: A

Explanation

The correct answer is A because using Analytics Hub allows for controlled access to datasets while keeping data secure and organized for each partner. Options B and C involve unnecessary data transfers and roles that provide broader access than required, while D grants access to the entire project, which does not meet the requirement of limiting access to individual datasets.