Answer-first summary for fast verification
Answer: Create and share an authorized view that provides the aggregate results.
The correct answer is A: Create and share an authorized view that provides the aggregate results. An authorized view in BigQuery allows you to share only the specific data you want while keeping the underlying user-level data secure and private. This helps in minimizing storage costs because the aggregate data takes up less storage space than duplicating tables. Additionally, the analysis costs will be assigned to the projects that run queries against the view, ensuring that the analysis cost for other projects is assigned to those projects.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
An organization oversees a Google BigQuery dataset encompassing tables with user-level data. The organization aims to make aggregated data from these tables accessible to other Google Cloud projects while preserving access control over the detailed user-level data. Moreover, the organization seeks to reduce their overall storage expenses and guarantee that the analysis costs incurred by other projects are allocated to those respective projects. What steps should they take?
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.