Question-34: You are an employee of QuickTechie Inc., which has a total workforce of 1500 people and operates under its own own identity and access management system. Your organisation is working on a project using Google Cloud that utilises BigQuery as a data warehouse. There are various tables that have information that may be used to identify an individual (PII). The PII is off limits to everyone save the compliance staff. The team working on the data science project needs to have access to the other information in the tables. You want to reduce both the expense of assigning proper access to the tables and the amount of time it takes to do so. What is it that you ought to do?
A. 1. From the dataset where you have the source data, create views of tables that you want to share, excluding PII. 2. Assign an appropriate project-level IAM role to the members of the data science team. 3. Assign access controls to the dataset that contains the view.
B. 1. From the dataset where you have the source data, create materialized views of tables that you want to share, excluding PII. 2. Assign an appropriate project-level IAM role to the members of the data science team. 3. Assign access controls to the dataset that contains the view.
C. 1. Create a dataset for the data science team. 2. Create views of tables that you want to share, excluding PII. 3. Assign an appropriate project-level IAM role to the members of the data science team. 4. Assign access controls to the dataset that contains the view. 5. Authorize the view to access the source dataset.
D. 1. Create a dataset for the data science team. 2. Create materialized views of tables that you want to share, excluding PII. 3. Assign an appropriate project-level IAM role to the members of the data science team. 4. Assign access controls to the dataset that contains the view. 5. Authorize the view to access the source dataset.
Correct Answer
Get All 340 Questions and Answer for Google Professional Cloud Architect
: 3 Explanation: The materialized view approach is too expensive for this purpose. That leaves out B & D. There is no need for the creation of a new dataset in order to safeguard PII. Developing a new perspective on the initial dataset ought to be adequate. View access may also be given at the 'dataset' level if desired. The correct answer is option 3. In BigQuery, the process of generating an authorised view is synonymous with the act of providing a view with access to a dataset. You are able to share query results with certain individuals and groups via the use of an approved view, but you do not have to provide them access to the underlying data. You may also limit the columns (fields) that users are allowed to query by using the SQL query that is associated with the view. You will learn how to build an authorised view by following this guide.