Google Cloud Professional Data Engineer — Question 157

Different teams in your organization store customer and performance data in BigQuery. Each team needs to keep full control of their collected data, be able to query data within their projects, and be able to exchange their data with other teams. You need to implement an organization-wide solution, while minimizing operational tasks and costs. What should you do?

Answer options

• A. Ask each team to create authorized views of their data. Grant the biquery.jobUser role to each team.
• B. Create a BigQuery scheduled query to replicate all customer data into team projects.
• C. Ask each team to publish their data in Analytics Hub. Direct the other teams to subscribe to them.
• D. Enable each team to create materialized views of the data they need to access in their projects.

Correct answer: C

Explanation

The correct answer is C because using Analytics Hub allows teams to publish their data, giving them control while facilitating sharing with other teams. Option A is incorrect because authorized views do not provide the same level of sharing flexibility. Option B is not optimal as replicating all data increases operational overhead and costs. Option D does not enable data sharing across teams effectively.