Google Professional Data Engineer Question 209
Select 2Google Cloud PlatformYour company wants to securely share aggregated sales data with multiple external partners. The data must be updated daily, and partners should not have direct access to your BigQuery datasets. Which of the following Google Cloud services and configurations can you use to achieve this using Analytics Hub?
- A
Create a BigQuery dataset, publish a data exchange in Analytics Hub, and share the dataset directly with partner accounts.
- B
Use Analytics Hub to publish a listing of aggregated sales data from a BigQuery dataset and allow partners to subscribe to the listing.
- C
Configure BigQuery row-level security and attach it to the dataset shared via Analytics Hub to restrict partners' access.
- D
Publish aggregated sales data as a BigQuery table and use Analytics Hub listings to control access without sharing direct table links.
- E
Export the aggregated sales data to Cloud Storage daily and share the Cloud Storage bucket with partners.
Show answer and explanation
Correct answers: B, D
Explanation
Analytics Hub is designed to facilitate secure data sharing between organizations without granting direct access to the underlying datasets. By publishing a listing in Analytics Hub, you can allow external partners to subscribe to and access aggregated data securely. This approach ensures that data is updated automatically and remains secure, without the need for manual data exports or direct dataset sharing.
- A. Incorrect.
This option is incorrect because Analytics Hub does not require sharing the dataset directly with partner accounts. It provides a way to share data listings securely without exposing the underlying dataset.
- B. Correct.
This option is correct because Analytics Hub allows you to publish a listing of data from a BigQuery dataset. Partners can subscribe to this listing to access the data without direct access to the dataset.
- C. Incorrect.
This option is incorrect because row-level security is not a feature used directly with Analytics Hub to manage access. Analytics Hub manages access at the listing level, not the row level.
- D. Correct.
This option is correct because you can publish aggregated sales data to a BigQuery table and use Analytics Hub to securely share access via listings, eliminating the need to share direct table links.
- E. Incorrect.
This option is incorrect because exporting data to Cloud Storage and sharing the bucket does not leverage Analytics Hub. It also introduces security and maintenance overhead compared to using Analytics Hub.