Google Cloud Professional Data Engineer Exam

What role should you grant business analysts in BigQuery to allow them to view data and run queries?

1. bigquery.resourceViewer and bigquery.dataViewer

2. bigquery.user and bigquery.dataViewer

3. bigquery.dataOwner

4. storage.objectViewer and bigquery.user

The correct answer is: bigquery.user and bigquery.dataViewer

Granting business analysts the role of bigquery.user along with bigquery.dataViewer is appropriate to enable them to view data and run queries in BigQuery. The bigquery.dataViewer role provides the necessary permissions for analysts to read data in specific datasets and to view metadata. This role ensures that users can access the datasets necessary for their analysis without modifying any data. The bigquery.user role enables users to run queries, which is essential for analysts whose primary role involves querying datasets for insights and reporting. This role gives the ability to create and schedule query jobs, which is critical for their workflow. This combination of roles ensures that business analysts have complete access to view and interact with the data they need for analysis while maintaining security by restricting them from making changes to the datasets. Other roles listed do not adequately provide the combination of read access to data and the ability to execute queries as effectively as this pairing.