An organization maintains a Google BigQuery dataset that contains tables with user-level data. They want to expose aggregates of this data to other Google Cloud projects, while still controlling access to the user-level data. Additionally, they need to minimize their overall storage cost and ensure the analysis cost for other projects is assigned to those projects. What should they do?
A) Create and share an authorized view that provides the aggregate results.
B) Create and share a new dataset and view that provides the aggregate results.
C) Create and share a new dataset and table that contains the aggregate results.
D) Create dataViewer Identity and Access Management (IAM) roles on the dataset to enable sharing.

Question

Quizplus · Accepted Answer

The Answer of An organization maintains a Google BigQuery dataset that contains tables with user-level data. They want to expose aggregates of this data to other Google Cloud projects, while still controlling access to the user-level data. Additionally, they need to minimize their overall storage cost and ensure the analysis cost for other projects is assigned to those projects. What should they do?
A) Create and share an authorized view that provides the aggregate results.
B) Create and share a new dataset and view that provides the aggregate results.
C) Create and share a new dataset and table that contains the aggregate results.
D) Create dataViewer Identity and Access Management (IAM) roles on the dataset to enable sharing.

An Organization Maintains a Google BigQuery Dataset That Contains Tables