You Are Migrating Your Data Warehouse to BigQuery

question 186

Multiple Choice

You are migrating your data warehouse to BigQuery. You have migrated all of your data into tables in a dataset. Multiple users from your organization will be using the data. They should only see certain tables based on their team membership. How should you set user permissions?

• A) Assign the users/groups data viewer access at the table level for each table
• B) Create SQL views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the SQL views
• C) Create authorized views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the authorized views
• D) Create authorized views for each team in datasets created for each team. Assign the authorized views data viewer access to the dataset in which the data resides. Assign the users/groups data viewer access to the datasets in which the authorized views reside

---

Definitions:

Selective Perception

The process by which individuals perceive what they want in media messages while ignoring opposing viewpoints.

Normative Influence

The impact of societal norms and expectations on an individual's behavior, often leading to conformity.

Informational Influence

The effect of others' opinions and knowledge on an individual's own attitudes, beliefs, and actions, based on the desire to be correct.

Virtual Groups

Groups of individuals who interact via digital platforms and communication technologies, typically for a shared purpose or goal, without meeting in physical spaces.