Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You use BigQuery to store your startup’s data related to your client’s orders and payment transaction logs. You hired a team of data analysts to create reports and several visualization dashboards for better presentation to shareholders and sharing in meetings and investor conferences. Some fields are sensitive and should not be viewed by anyone other than you. You want data analysts to query the data without having access to the sensitive columns. What would you do?
A. Grant data analysts viewer role on tables with specifying what columns data analysts are authorized to query.
B. Create authorized views on tables in the same dataset in which the tables reside. Grant viewer role to data analysts on the views.
C. Create a new dataset in BigQuery. Create authorized views on tables. Grant viewer role to data analysts on the new dataset.
D. Create a new dataset in BigQuery. Grant viewer role to data analysts on the new dataset. Copy the tables from the current dataset to the new one with columns data analysts are authorized to query.
Correct Answer: C
Option A is incorrect: In the dataset, there are tables o views, but in the option, it’s talking about “viewer role on the table” which is not correct and supported. granting access to a table will not help to restrict access to data in the column of a table.
Option B is incorrect: It is not a best practice to create an authorized view on the original dataset.
Option C is correct: It is the best practice to create a new dataset and create authorized views.
Option D is incorrect: No need to copy tables when you can use authorized views.
Source(s):
BigQuery – Authorized Views:
https://cloud.google.com/bigquery/docs/authorized-views#console
Comments are closed, but trackbacks and pingbacks are open.