Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data analyst with the bigquery.dataViewer role can query a materialized view but needs the ability to refresh it without gaining additional permissions. Which predefined BigQuery role should you assign to meet this requirement?
bigquery.dataViewer
A
bigquery.dataOwner - Grants full control over datasets and tables, including creation, deletion, and modification.
bigquery.dataOwner
B
bigquery.admin - Provides administrative control over BigQuery resources, offering more permissions than needed.
bigquery.admin
C
bigquery.dataEditor - Allows reading and modifying data within tables but does not specifically enable refreshing materialized views.
bigquery.dataEditor
D
bigquery.mvUpdater - Specifically designed for refreshing materialized views without granting unnecessary access.
bigquery.mvUpdater
