Google Cloud Professional Data Engineer — Question 302

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?

Answer options

• 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.

Correct answer: A

Explanation

Creating and sharing an authorized view is the best option because it allows the organization to provide aggregate results while keeping user-level data secure. Other options, such as creating new datasets or tables, could lead to increased storage costs and less efficient access control. Additionally, assigning IAM roles does not directly address the requirement of exposing aggregates without revealing sensitive data.