Assign the BigQuery dataViewer user role to the group.

Answer: C

Explanation:

Read the dataset’s metadata and to list tables in the dataset. Read data and metadata from the dataset’s tables. When applied at the project or organization level, this role can also enumerate all datasets in the project. Additional roles, however, are necessary to allow the running of jobs.

BigQuery Data Viewer

(roles/bigquery.dataViewer)

When applied to a table or view, this role provides permissions to:

Read data and metadata from the table or view.

This role cannot be applied to individual models or routines.

When applied to a dataset, this role provides permissions to:

Read the dataset’s metadata and list tables in the dataset.

Read data and metadata from the dataset’s tables.

When applied at the project or organization level, this role can also enumerate all datasets in the

project. Additional roles, however, are necessary to allow the running of jobs.

Lowest-level resources where you can grant this role:

Table

View

BigQuery Job User

(roles/bigquery.jobUser)

Provides permissions to run jobs, including queries, within the project.

Lowest-level resources where you can grant this role:

Project

to run jobs https://cloud.google.com/bigquery/docs/access-control#bigquery.jobUser databaseUser needs additional role permission to run jobs

https://cloud.google.com/spanner/docs/iam#spanner.databaseUser