Explanation:
The bigquery.mvUpdater role is the most appropriate choice as it precisely grants the permission to refresh materialized views without providing additional, unnecessary access to other data or resources. Other roles like bigquery.dataOwner, bigquery.admin, and bigquery.dataEditor offer broader permissions that exceed the requirement for simply refreshing a materialized view.
Ultimate access to all questions.
No comments yet.
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?
A
bigquery.dataOwner - Grants full control over datasets and tables, including creation, deletion, and modification.
B
bigquery.admin - Provides administrative control over BigQuery resources, offering more permissions than needed.
C
bigquery.dataEditor - Allows reading and modifying data within tables but does not specifically enable refreshing materialized views.
D
bigquery.mvUpdater - Specifically designed for refreshing materialized views without granting unnecessary access.