How to share BigQuery datasets self-servingly and cost-effectively?

PDE By islever Editorial Last updated

Short answer

A Create an Analytics Hub private exchange, and publish the sales dataset.

Question

You designed a data warehouse in BigQuery to analyze sales data. You want a self-serving, low-maintenance, and cost- effective solution to share the sales dataset to other business units in your organization. What should you do?
  1. Create an Analytics Hub private exchange, and publish the sales dataset. Correct Answer
  2. Enable the other business units’ projects to access the authorized views of the sales dataset.
  3. Create and share views with the users in the other business units.
  4. Use the BigQuery Data Transfer Service to create a schedule that copies the sales dataset to the other business units’ projects.

Key Takeaways

The question tests the ability to select a centralized data exchange platform (Analytics Hub) over manual view sharing or data duplication to achieve self-service and cost-efficiency.

Analytics Hub private exchanges provide the optimal solution for sharing BigQuery datasets internally, offering self-service access while minimizing maintenance and storage costs.

Common mistake: Choosing authorized views (Option B) is a common mistake; while it works for security

Expert Analysis

Why the Answer Is Correct

Analytics Hub allows organizations to create private exchanges for secure internal data sharing. It enables self-service discovery for business units, eliminates the need for data duplication (saving costs), and centralizes access control (low maintenance), perfectly matching the scenario's requirements.

Why the Other Options Are Wrong

Authorized views (Option B) and direct view sharing (Option C) require manual IAM management and lack a discovery interface, increasing maintenance overhead. Data Transfer Service (Option D) duplicates data, incurring unnecessary storage costs and complexity, violating the cost-effective and low-maintenance criteria.

Community Comment Notes

Community consensus is unanimous for Option A, highlighting that Analytics Hub simplifies access control management and serves as a centralized platform for data sharing, aligning with the question's constraints.

Official Reference

https://cloud.google.com/analytics-hub

This link opens the official vendor documentation in a new tab.

Exam Strategy

When questions ask for self-service, low-maintenance, and cost-effective data sharing, prioritize native exchange solutions like Analytics Hub over manual IAM configurations or data replication methods.

Community Votes

A
100%

100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 5 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 5

  1. raaad 👍 7 Answered A
    Analytics Hub offers a centralized platform for managing data sharing and access within the organization. This simplifies access control management.
  2. scaenruy 👍 1 Answered A
    A. Create an Analytics Hub private exchange, and publish the sales dataset.
  3. 987af6b 👍 1 Answered A
    A. is the answer I select
  4. JyoGCP 👍 1 Answered A
    Analytics Hub
  5. Matt_108 👍 1 Answered A
    Definitely A

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

How to establish consistent BigQuery spend?

S-grade

Triggering Airflow DAGs Reactively in Private Cloud Composer

S-grade

How to resolve Cloud Composer 2 worker pod evictions and task failures?

S-grade

Which Google Cloud database for on-prem PostgreSQL with analytics?

S-grade

← Back to PDE Study Guide