Google Professional Cloud Architect
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
Your company captures all web traffic data in Google Analytics 360 and stores it in BigQuery, with each country having its own dataset containing multiple tables. To maintain data security and privacy, it is crucial that analysts from each country can only see and query the data specific to their own country. Given this requirement, how should you configure the access rights in BigQuery?
Explanation:
The correct answer is A. In order to ensure that analysts can query the data relevant to their respective countries, the BigQuery jobUser role is required because it provides permissions to run jobs, including queries within the project. The datasets should then be shared with view access with each respective country-group. This approach ensures that analysts can only see and query data for their specific countries, meeting the requirement of limited data access. The BigQuery dataViewer role alone does not grant the ability to run queries, which is why jobUser is necessary.