PROFESSIONAL-DATA-ENGINEER Question #326: Real Exam Question with Answer & Explanation

Question

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?

Options

• AAsk each team to create authorized views of their data. Grant the biquery.jobUser role to each team.
• BCreate a BigQuery scheduled query to replicate all customer data into team projects.
• CAsk each team to publish their data in Analytics Hub. Direct the other teams to subscribe to them.
• DEnable each team to create materialized views of the data they need to access in their projects.

Explanation

Analytics Hub is Google Cloud's managed data exchange platform designed exactly for this use case - it lets each team publish their datasets as listings while other teams subscribe to them, maintaining ownership and access control without copying data, which minimizes both operational overhead and storage costs.

Why the distractors fail:

• A (Authorized Views + bigquery.jobUser): Authorized views allow cross-project querying, but managing view permissions org-wide is operationally intensive and doesn't scale cleanly across many teams.
• B (Scheduled query replication): Replicating data into every team's project creates redundant storage costs, introduces data freshness lag, and adds ongoing pipeline maintenance - the opposite of minimizing cost and ops work.
• D (Materialized views): Like option B, materialized views duplicate data and require teams to manually manage refresh schedules, increasing both cost and operational burden.

Memory tip: Think of Analytics Hub as a "data marketplace inside your org" - publishers list, subscribers link (not copy). Whenever an exam question mentions data sharing + minimal ops + no duplication, Analytics Hub is the answer.

No community discussion yet for this question.