Discuss Google Associate Data Practitioner Exam Topic 2 Question 14

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.

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.

Get Premium Associate Data Practitioner Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

27 comments · newest first

Lorrine 10 months ago

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

Glory 10 months ago

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

Shaniqua 11 months ago

D sounds risky, giving too much access.

Danica 11 months ago

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

Charolette 11 months ago

A is the best choice for secure sharing!

Larue 11 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.

Hui 11 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.

Nilsa 12 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?

Kaitlyn 12 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.

Lanie 1 year 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.

Mariann 1 year 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.

Omer 1 year 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.

Julene 1 year 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.

Emily 1 year ago

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

Abraham 1 year 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?

Kimi 1 year ago

↳ replying to Abraham

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.

Sylvie 1 year ago

↳ replying to Abraham

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.

Lemuel 1 year 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.

Joseph 1 year ago

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

Ora 1 year ago

↳ replying to Joseph

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.

Gail 1 year ago

↳ replying to Joseph

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.

Edwin 1 year 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.

Doyle 1 year ago

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

Reita 1 year 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.

Carey 1 year ago

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

Xuan 1 year ago

↳ replying to Carey

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.

Carolann 1 year ago

↳ replying to Carey

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.

Google Associate Data Practitioner Exam - Topic 2 Question 14 Discussion