Question 15

Question

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?

Accepted Answer

Create 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.

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE