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:

Nitrogen Base

A component of nucleotides in DNA and RNA, which includes adenine, thymine (in DNA), uracil (in RNA), guanine, and cytosine.

Uracil

A nitrogen-containing base found in RNA, where it pairs with adenine and replaces thymine during DNA transcription.

RNA

Ribonucleic acid is a type of nucleic acid found in every living cell, serving as a messenger that transports directions from DNA for the production of proteins.

Nitrogen Bases

Organic molecules that make up the building blocks of DNA and RNA, including adenine, thymine, cytosine, guanine, and uracil.