SnowPro Core

Snowflake provides a mechanism called 'clustering keys' that allows customers to manage and optimize the clustering of their data. This method enables users to specify key columns that control how the data is physically stored and accessed, improving query performance for specified patterns.

The two valid Snowflake Virtual Warehouse Scaling Policies are Economy and Standard. The Economy policy helps to minimize cost by reducing the number of active warehouses when the workload decreases, while the Standard policy provides balanced performance by scaling the number of warehouses based on the query load.

A single database cannot exist in more than one Snowflake account. Each database is associated with one specific Snowflake account. While data can be shared between accounts or replicated, each instance of a database is unique to a single account.

The SECURITYADMIN role is designed specifically to handle security-related tasks, including the creation and management of users and roles. This role has the necessary privileges to manage all aspects of user and role administration, making it the recommended choice for these tasks. This aligns with the principle of least privilege, ensuring that higher-level administrative privileges are not unnecessarily granted.

Bulk unloading of data from Snowflake supports the use of a SELECT statement. The COPY INTO <location> command can accept a SELECT statement which allows the results of the query to be written to files and stored in the specified location. This feature makes it possible to unload data based on specific query criteria.