Practice Test 2 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test

Marketing team in your company wants to access certain tables in BigQuery. These tables are stored along with other tables considered sensitive and it’s not approved to be accessed by marketing team. You need to restrict marketing team’s role to only read from the tables they are allowed to.

Which of the following actions will you take?

A. Assign marketing team’s roles as viewers on these specific tables. They won’t be able to select from other tables in the dataset.
B. Create authorized views on tables marketing team wants to read from on the same dataset tables reside in. Grant viewer role to marketing team on the views.
C. Create a new dataset in BigQuery. Grant viewer role to marketing team on the new dataset. Copy the tables from the current dataset to the new one.
D. Create a new dataset in BigQuery. Create authorized views on tables marketing team wants to read from. Grant viewer role to marketing team on new dataset.