Which steps will help optimize query performance? (Select TWO).
Using the query acceleration service
Clustering a table
Indexing a column
Increasing the size of the micro-partitions
Decreasing the size of the virtual warehouse
Snowflake users can create a resource monitor at which levels? (Select TWO).
User level
Pipe level
Account level
Cloud services level
Virtual warehouse level
Resource monitors in Snowflake are tools used to track and control the consumption of compute resources, ensuring that usage stays within defined limits. These monitors can be created at the account level, allowing administrators to set overall resource consumption limits for the entire Snowflake account. Additionally, resource monitors can be set at the virtual warehouse level, enabling more granular control over the resources consumed by individual warehouses. This dual-level capability allows organizations to manage their Snowflake usage efficiently, preventing unexpected costs and optimizing performance.References: Snowflake Documentation on Resource Monitors
Top of Form
What happens to the privileges granted to Snowflake system-defined roles?
The privileges cannot be revoked.
The privileges can be revoked by an ACCOUNTADMIN.
The privileges can be revoked by an orgadmin.
The privileges can be revoked by any user-defined role with appropriate privileges.
The privileges granted to Snowflake's system-defined roles cannot be revoked. System-defined roles, such as SYSADMIN, ACCOUNTADMIN, SECURITYADMIN, and others, come with a set of predefined privileges that are essential for the roles to function correctly within the Snowflake environment. These privileges are intrinsic to the roles and ensure that users assigned these roles can perform the necessary tasks and operations relevant to their responsibilities.
The design of Snowflake's role-based access control (RBAC) model ensures that system-defined roles have a specific set of non-revocable privileges to maintain the security, integrity, and operational efficiency of the Snowflake environment. This approach prevents accidental or intentional modification of privileges that could disrupt the essential functions or compromise the security of the Snowflake account.
References:
Snowflake Documentation on Access Control: Understanding Role-Based Access Control (RBAC)
Which command can be used to unload data into an external named stage in Snowflake?
PUT
CREATE
COPY INTO