Google Professional Cloud Architect

Get started today

Ultimate access to all questions.

Quick Answer

Answer-first summary for fast verification

Answer: 1. Create a dataset for the data science team. 2. Create views of tables that you want to share, excluding PII. 3. Assign an appropriate project-level IAM role to the members of the data science team. 4. Assign access controls to the dataset that contains the view. 5. Authorize the view to access the source dataset.

The correct answer is C based on Google's official documentation for authorized views in BigQuery and the community consensus. Option C follows the recommended security best practice of creating a separate dataset for the data science team, then creating views that exclude PII, and authorizing those views to access the source dataset. This approach ensures that data scientists can only access non-PII data through the views without having direct access to the underlying tables containing PII. While option A is simpler and some community members argued it would minimize cost/time, Google's official documentation explicitly states that authorized views should be created in a different dataset from the source data to properly isolate access. Options B and D are eliminated because materialized views incur additional storage costs and are not necessary for access control purposes, contradicting the requirement to minimize cost.

Author: LeetQuiz Editorial Team

Quick Answer

Answer-first summary for fast verification

Author: LeetQuiz Editorial Team

Comments (0)

No comments yet.

Your company has a Google Cloud project using BigQuery for data warehousing. Some tables contain personally identifiable information (PII) that only the compliance team is permitted to access. The remaining data in these tables must be accessible to the data science team. Your goal is to minimize both cost and the time required to assign appropriate table access. What should you do?

Exam-Like

Last updated: February 4, 2026 at 14:03

From the dataset where you have the source data, create views of tables that you want to share, excluding PII. 2. Assign an appropriate project-level IAM role to the members of the data science team. 3. Assign access controls to the dataset that contains the view.

0.0%

From the dataset where you have the source data, create materialized views of tables that you want to share, excluding PII. 2. Assign an appropriate project-level IAM role to the members of the data science team. 3. Assign access controls to the dataset that contains the view.

0.0%

Create a dataset for the data science team. 2. Create views of tables that you want to share, excluding PII. 3. Assign an appropriate project-level IAM role to the members of the data science team. 4. Assign access controls to the dataset that contains the view. 5. Authorize the view to access the source dataset.

Create a dataset for the data science team. 2. Create materialized views of tables that you want to share, excluding PII. 3. Assign an appropriate project-level IAM role to the members of the data science team. 4. Assign access controls to the dataset that contains the view. 5. Authorize the view to access the source dataset.