Snowflake SnowPro Core Practice Test - Questions Answers, Page 35

The USERADMIN role in Snowflake has the ability to create and manage users and roles within the Snowflake environment.This role is specifically dedicated to user and role management and creation

Topic 4, Exam pool D

In Snowflake, a user with the SECURITYADMIN role or higher can activate and enforce a network policy for all users in an account.Additionally, a role that has ownership of the network policy can also activate and enforce it

In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created4.

An account administrator in the Data Exchange can perform tasks such as adding and removing members and approving or denying listing approval requests.These tasks are part of managing the Data Exchange and ensuring that only authorized listings and members are part of it12.

The statistics that can be used to identify queries with inefficient pruning are 'Partitions scanned' and 'Partitions total'.These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.

The GOVERNANCE_VIEWER role in the ACCOUNT_USAGE schema provides visibility into policy-related information within Snowflake.This role is specifically designed to access views that display object metadata and usage metrics related to governance12.

The Snowflake data types that can be used to build nested hierarchical data are OBJECT and VARIANT.These data types support the storage and querying of semi-structured data, allowing for the creation of complex, nested data structures

Once an internal stage is dropped in Snowflake, it cannot be recovered or restored using Time Travel or UNDROP commands.The only option is to recreate the dropped stage

In a regular schema within Snowflake, the object owner has the privilege to grant object privileges.The object owner is typically the role that created the object or to whom the ownership of the object has been transferred78.

Reference = [COF-C02] SnowPro Core Certification Exam Study Guide