GoogleGoogle Professional Cloud Architect (PCA) Certification Exam·EN·Updated 14 Jul 2026
Your company captures all web traffic data in Google Analytics 360 and stores it in BigQuery. Each country has its own dataset. Each dataset has multiple tables. You want analysts from each country to be able to see and query only the data for their respective countries. How should you configure the access rights?
Choose an answer
Tap an option to check your answer.
Correct answer: Create a group per country. Add analysts to their respective country-groups. Create a single group 'all_analysts', and add all country-groups as members. Grant the 'all_analysts' group the IAM role of BigQuery jobUser. Share the appropriate dataset with view access with each respective analyst country-group..
Why this is the answer
The correct option uses a hierarchical group structure and grants permissions at the appropriate level. Creating country-specific groups and adding them to an 'allanalysts' group simplifies management. Granting BigQuery Job User to 'allanalysts' allows them to run queries, which is a fundamental requirement. Sharing the dataset with view access to each country's group ensures analysts can see all tables within their country's dataset, while restricting access to other countries' data.
The incorrect options either grant permissions at the wrong level (table instead of dataset) or use an incorrect IAM role (BigQuery Data Viewer, which is too broad and provides read-only access to all datasets and tables in a project, not just query execution). Sharing tables individually would be cumbersome and less scalable than sharing at the dataset level.