Explore the GOVERNANCE_VIEWER role in Snowflake’s ACCOUNT_USAGE schema, providing visibility into policy-related information for effective governance and auditing in your Snowflake environment.
Table of Contents
Question
Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
A. USAGE_VIEWER
B. GOVERNANCE_VIEWER
C. OBJECT_VIEWER
D. SECURITY_VIEWER
Answer
B. GOVERNANCE_VIEWER
Explanation
The GOVERNANCE_VIEWER role in Snowflake’s ACCOUNT_USAGE schema provides visibility into policy-related information, including information about:
- Resource Monitors: View details on resource monitors, which are used to set limits on warehouse resources like credit usage, query execution time, and more.
- Policies: View information on various policies applied in the account, such as row access policies, column access policies, masking policies, and others.
- Streams: View details on streams, which are used for capturing changes in database objects and replicating them to other locations.
- Tasks: View information on tasks, which are scheduled operations that automate various processes like loading data, executing SQL statements, and more.
By granting the GOVERNANCE_VIEWER role, you can ensure that relevant users or roles have the necessary permissions to monitor and audit the implementation of governance policies and controls within the Snowflake account.
Snowflake SnowPro Core certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core exam and earn Snowflake SnowPro Core certification.