Your company has a Google Cloud project that uses BigQuery for data warehousing. There are some tables that contain personally identifiable information (PII). Only the compliance team may access the…

Question

Exhibit

Options

• A
  1. From the dataset where you have the source data, create views of tables that you want to
• B
  1. From the dataset where you have the source data, create materialized views of tables that you
• C
  1. Create a dataset for the data science team.
• D
  1. Create a dataset for the data science team.

• A
  10% (3)
• B
  3% (1)
• C
  83% (24)
• D
  3% (1)

Explanation

You need to create a new dataset based on a query from the source dataset first before you can create the authorised view. https://cloud.google.com/bigquery/docs/share-access- views#create_a_dataset_where_you_can_store_your_view After creating your source dataset, you create a new, separate dataset to store the authorized view that you share with your data analysts. In a later step, you grant the authorized view access to the data in the source dataset. Your data analysts then have access to the authorized view, but not direct access to the source data.

No community discussion yet for this question.