Google Exam Professional Cloud Developer Topic 14 Question 28 Discussion

Actual exam question for Google's Professional Cloud Developer exam

Question #: 28
Topic #: 14

[All Professional Cloud Developer Questions]

Your company has a BigQuery dataset named "Master" that keeps information about employee travel and expenses. This information is organized by employee department. That means employees should only be able to view information for their department. You want to apply a security framework to enforce this requirement with the minimum number of steps.

What should you do?

ACreate a separate dataset for each department. Create a view with an appropriate WHERE clause to
select records from a particular dataset for the specific department. Authorize this view to access records from your Master dataset. Give employees the permission to this department-specific dataset.

BCreate a separate dataset for each department. Create a data pipeline for each department to copy
appropriate information from the Master dataset to the specific dataset for the department. Give employees the permission to this department-specific dataset.

CCreate a dataset named Master dataset. Create a separate view for each department in the Master
dataset. Give employees access to the specific view for their department.

DCreate a dataset named Master dataset. Create a separate table for each department in the Master
dataset. Give employees access to the specific table for their department.

Show Suggested Answer

Suggested Answer: B

by Joesph at May 07, 2022, 01:27 PM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!