Google
PROFESSIONAL-DATA-ENGINEER · Question #232
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 certa
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #232. The question stem and answer options stay visible for context.
Submitted by miguelv· Mar 30, 2026Ensuring solution quality
Question
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?
Options
- AAssign the users/groups data viewer access at the table level for each table
- BCreate 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
- CCreate 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
- DCreate 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
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BigQuery authorized views#table-level access#IAM permissions#data sharing