An Organization Maintains a Google BigQuery Dataset That Contains Tables

question 52

Multiple Choice

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.

---

Definitions:

Monthly Consumption

The total amount of goods and services that consumers purchase and use within a month.

Monthly Income

The total earnings received by an individual or entity on a monthly basis, from sources such as employment, investments, and other income.

Income Elasticity of Demand

Indicates how the quantity demanded of a good changes in response to a change in consumers' income.

Monthly Income

The total amount of earnings received every month from work, investments, benefits, and other sources.