Question 230 of 318
Single answerYour organization uses BigQuery to process highly sensitive, structured datasets. Following the “need to know†principle, you need to create the Identity and Access Management (IAM) design to meet the needs of these users:
• Business user: must access curated reports.
• Data engineer: must administrate the data lifecycle in the platform.
• Security operator: must review user activity on the data platform.
What should you do?
• Business user: must access curated reports.
• Data engineer: must administrate the data lifecycle in the platform.
• Security operator: must review user activity on the data platform.
What should you do?
AConfigure data access log for BigQuery services, and grant Project Viewer role to security operator.
BSet row-based access control based on the “region†column, and filter the record from the United States for data engineers.
✓CCreate curated tables in a separate dataset and assign the role roles/bigquery.dataViewer.
DGenerate a CSV data file based on the business user's needs, and send the data to their email addresses.
✓
Correct Answer: C
Create curated tables in a separate dataset and assign the role roles/bigquery.dataViewer.
▥
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.