Answer-first summary for fast verification
Answer: Create and share an authorized view that offers the aggregate results.
The optimal method involves creating and sharing an authorized view that provides aggregate results. This approach ensures: - **Data Control**: Authorized views act as virtual tables, displaying only the results of a specified SQL query, thus restricting access to underlying user-level data. - **Cost Efficiency**: Since authorized views don't store additional data, they eliminate the need for separate data copies, reducing storage and analysis costs. - **Ease of Sharing**: These views can be easily shared across projects within or outside the organization. Other options are less ideal due to increased storage needs, potential data inconsistencies, or lack of inherent data aggregation capabilities. Ref: [Google Cloud BigQuery Documentation](https://cloud.google.com/bigquery/docs/share-access-views)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can an organization efficiently share aggregated data from their Google BigQuery dataset with other Google Cloud projects, ensuring control over the original user-level data and minimizing costs?
A
Establish a new dataset and table containing the aggregated results for sharing.
B
Create and share an authorized view that offers the aggregate results.
C
Implement dataViewer IAM roles on the dataset to facilitate sharing.
D
Develop a new dataset and view that provides the aggregate results for sharing.
No comments yet.