Question 283 of 307
Single answerYou have a BigQuery dataset named “customersâ€. All tables will be tagged by using a Data Catalog tag template named “gdprâ€. The template contains one mandatory field, “has_sensitive_dataâ€, with a boolean value. All employees must be able to do a simple search and find tables in the dataset that have either true or false in the “has_sensitive_data’ field. However, only the Human Resources (HR) group should be able to see the data inside the tables for which “has_sensitive data†is true. You give the all employees group the bigquery.metadataViewer and bigquery.connectionUser roles on the dataset. You want to minimize configuration overhead. What should you do next?
ACreate the “gdpr†tag template with private visibility. Assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.
BCreate the “gdpr†tag template with private visibility. Assign the datacatalog.tagTemplateViewer role on this tag to the all employees group, and assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.
✓CCreate the “gdpr†tag template with public visibility. Assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.
DCreate the “gdpr†tag template with public visibility. Assign the datacatalog.tagTemplateViewer role on this tag to the all employees group, and assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.
✓
Correct Answer: C
Create the “gdpr†tag template with public visibility. Assign the bigquery.dataViewer role to the HR group on the tables that contain sensitive data.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.