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…

Question

Options

• ACreate a separate dataset for each department. Create a view with an appropriate WHERE
• BCreate a separate dataset for each department. Create a data pipeline for each department to
• CCreate a dataset named Master dataset. Create a separate view for each department in the
• DCreate a dataset named Master dataset. Create a separate table for each department in the

• A
  2% (1)
• B
  9% (5)
• C
  83% (45)
• D
  6% (3)

Explanation

The most efficient approach is to keep a single 'Master' dataset and create one authorized view per department within it, each with a WHERE clause filtering to that department's data. You then grant each department's employees access only to their corresponding view. This requires the fewest steps: one dataset, one table, N views. Creating a separate dataset per department (A or B) multiplies management overhead and requires data pipelines or duplication. Creating a separate table per department (D) inside one dataset still exposes the underlying tables unless views are used.

No community discussion yet for this question.