ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam
Go to Exam

Exam Associate Data Practitioner topic 1 question 60 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 60
Topic #: 1
[All Associate Data Practitioner Questions]

Your organization has highly sensitive data that gets updated once a day and is stored across multiple datasets in BigQuery. You need to provide a new data analyst access to query specific data in BigQuery while preventing access to sensitive data. What should you do?

  • A. Grant the data analyst the BigQuery Job User IAM role in the Google Cloud project.
  • B. Create a materialized view with the limited data in a new dataset. Grant the data analyst BigQuery Data Viewer IAM role in the dataset and the BigQuery Job User IAM role in the Google Cloud project.
  • C. Create a new Google Cloud project, and copy the limited data into a BigQuery table. Grant the data analyst the BigQuery Data Owner IAM role in the new Google Cloud project.
  • D. Grant the data analyst the BigQuery Data Viewer IAM role in the Google Cloud project.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by n2183712847 at March 6, 2025, 5:46 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
n2183712847
1 month, 4 weeks ago
Selected Answer: B
The best option is B. Materialized view in new dataset + Data Viewer & Job User roles. Option B is best because it uses a view to limit data access and dataset-level permissions for least privilege. Option A (Job User only) is incorrect because it grants no data access. Option C (New project & Data Owner) is incorrect because it's overly complex and too permissive (Data Owner role). Option D (Project Data Viewer) is incorrect because it grants access to all datasets, including sensitive ones. Therefore, Option B is the most secure and least privileged way to grant access to specific data.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago