ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to Exam

Exam Professional Data Engineer topic 1 question 244 discussion

Actual exam question from Google's Professional Data Engineer
Question #: 244
Topic #: 1
[All Professional Data Engineer Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by rahulvin at Dec. 30, 2023, 6:24 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
raaad
Highly Voted 9 months, 4 weeks ago
Selected Answer: C
- Analytics Hub allows organizations to create and manage exchanges where producers can publish their data and consumers can discover and subscribe to data products. - Asking each team to publish their data in Analytics Hub and having other teams subscribe to them is a scalable and controlled way of sharing data. - It minimizes operational tasks because data doesn't need to be duplicated or manually managed after setup, and teams can maintain full control over their datasets.
upvoted 5 times
...
CGS22
Most Recent 6 months, 3 weeks ago
Selected Answer: C
Why C is the best choice: Centralized Data Exchange: Analytics Hub provides a unified platform for data sharing across teams and organizations. It simplifies the process of publishing, discovering, and subscribing to datasets, reducing operational overhead. Data Ownership and Control: Each team retains full control over their data, deciding which datasets to publish and who can access them. This ensures data governance and security. Cross-Project Querying: Once a team subscribes to a dataset in Analytics Hub, they can query it directly from their own BigQuery project, enabling seamless data access without data replication. Cost Efficiency: Analytics Hub eliminates the need for data duplication or complex ETL processes, reducing storage and processing costs.
upvoted 1 times
...
hanoverquay
7 months, 1 week ago
Selected Answer: C
vote C
upvoted 1 times
...
JyoGCP
8 months, 1 week ago
Selected Answer: C
C. Analytics Hub
upvoted 1 times
...
Matt_108
9 months, 2 weeks ago
Selected Answer: C
that's what analytics hub is designed for
upvoted 2 times
...
rahulvin
10 months ago
Selected Answer: C
Analytics hub to reduce operational overhead of creating/maintaining views permissions etc
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago