ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam
Go to Exam

Exam Associate Data Practitioner topic 1 question 65 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 65
Topic #: 1
[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 data. You want to share the data while following Google-recommended practices. What should you do?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by n2183712847 at March 6, 2025, 5:09 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
n2183712847
1 month, 4 weeks ago
Selected Answer: 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.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago