To view and modify resource monitors, the least privileges needed are MONITOR and MODIFY. These privileges allow a user to monitor credit usage and make changes to resource monitors3.

Scalar functions in Snowflake (and SQL in general) are designed to return a single value for each invocation.
They operate on a single value and return a single result, making them suitable for a wide range of data transformations and calculations within queries.
References:
* Snowflake Documentation: Functions

Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region to another region or cloud provider. This is because the data transfer incurs costs associated with moving data across different networks. Egress charges are not applied for data sharing within the same region, query result retrieval, or loading data into Snowflake, as these actions do not involve data transfer across regions.
References:
* [COF-C02] SnowPro Core Certification Exam Study Guide
* Snowflake Documentation on Data Replication and Egress Charges1

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