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

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. Source Reference 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.

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.

Community Insight

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.

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

Community Discussion (5 comments)

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

Comments & Corrections

No comments 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.

Submitted for moderation before publishing. Keep it helpful and respectful.

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

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.

Related Analysis

← Back to PDE Study Guide