Each country has its own BigQuery dataset and analysts must only query their country's data. How should you configure access?
Choose an answer
Tap an option to check your answer.
Correct answer: Create a Google group per country and add analysts. Create an 'all_analysts' group containing the country groups. Grant 'all_analysts' the BigQuery jobUser role. Share each country dataset with its country group as a view..
Why this is the answer
This solution uses views to restrict access at the row level, ensuring analysts only see data for their country. The 'allanalysts' group with the BigQuery jobUser role allows all analysts to run queries, but the view definition itself enforces the data segregation. Sharing tables directly (incorrect options 2 and 4) would give analysts access to all rows in those tables, violating the requirement. Granting BigQuery dataViewer to 'allanalysts' (incorrect options 3 and 4) would give broad read access to all datasets, which is not granular enough for this scenario. The view-based approach is the most secure and efficient for row-level access control in BigQuery.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed