Google Associate Data Practitioner Exam - 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%

Off

Get Premium Associate Data Practitioner Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lorrine

3 months ago

Wait, can partners really only access their own datasets with A?

upvoted 0 times

...

Glory

3 months ago

C is a bit outdated, right? Why not keep it in BigQuery?

upvoted 0 times

...

Shaniqua

3 months ago

D sounds risky, giving too much access.

upvoted 0 times

...

Danica

3 months ago

I disagree, B seems more efficient for real-time data.

upvoted 0 times

...

Charolette

3 months ago

A is the best choice for secure sharing!

upvoted 0 times

...

Larue

4 months ago

I have a vague memory of Dataflow being mentioned, but I’m not confident that option B is the right approach for just sharing datasets.

upvoted 0 times

...

Hui

4 months ago

I practiced a similar question where we had to restrict access. I think option C could work, but it might not be the most efficient way to share data.

upvoted 0 times

...

Nilsa

4 months ago

I'm not entirely sure, but I feel like option D could lead to too much access for the partners. We want to limit their access, right?

upvoted 0 times

...

Kaitlyn

4 months ago

I remember we discussed using Analytics Hub in class, so I think option A might be the best choice for sharing datasets securely.

upvoted 0 times

...

Lanie

5 months ago

I'm feeling pretty confident about this one. Option A is the clear winner in my opinion. It follows the recommended practices and gives me the most control over the data sharing.

upvoted 0 times

...

Mariann

5 months ago

Okay, I think I've got this. Option A with Analytics Hub seems like the way to go - it allows me to share the data securely while giving each partner access to only their own dataset.

upvoted 0 times

...

Omer

5 months ago

Hmm, I'm a bit confused by the options here. I'll need to review the details of each approach to understand the differences and decide which one is best.

upvoted 0 times

...

Julene

5 months ago

This looks like a tricky one. I'll need to think through the Google-recommended practices carefully to make sure I choose the right approach.

upvoted 0 times

...

Emily

7 months ago

I agree with Doyle, using Analytics Hub seems like the most secure and efficient way to share the data with our external partners.

upvoted 0 times

...

Abraham

7 months ago

Ah, the age-old dilemma of data sharing. Option A for the win! Kinda makes me wish I had a data exchange membership card, you know?

upvoted 0 times

Kimi

6 months ago

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.

upvoted 0 times

...

Sylvie

6 months ago

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.

upvoted 0 times

...

Lemuel

7 months ago

I think creating a Dataflow job that reads from each BigQuery dataset and pushes the data into a dedicated Pub/Sub topic for each partner is the best option.

upvoted 0 times

...

Joseph

8 months ago

D is a nope. Giving partners bigquery.user access is a security risk. We need more granular control.

upvoted 0 times

Ora

7 months ago

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.

upvoted 0 times

...

Gail

7 months ago

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.

upvoted 0 times

...

Edwin

8 months ago

I disagree, I believe we should export the BigQuery data to a Cloud Storage bucket and grant the partners the storage.objectUser IAM role.

upvoted 0 times

...

Doyle

8 months ago

I think we should use Analytics Hub to create a listing on a private data exchange for each partner dataset.

upvoted 0 times

...

Reita

8 months ago

I'm not sure about Dataflow and Pub/Sub. Seems a bit overkill for this use case. I'd go with C, exporting to Cloud Storage.

upvoted 0 times

...

Carey

8 months 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

Xuan

7 months ago

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.

upvoted 0 times

...

Carolann

7 months ago

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.

upvoted 0 times

...