Query pruning in Snowflake is the mechanism used to limit the number of micro-partitions scanned by a query. By analyzing the filters and conditions applied in a query, Snowflake can skip over micro-partitions that do not contain relevant data, thereby reducing the amount of data processed and improving query performance. This technique is particularly effective for large datasets and is a key component of Snowflake ' s performance optimization features.
References:
Snowflake Documentation: Query Performance Optimization

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

The primary responsibility of Snowflake's virtual warehouses is to execute queries. Virtual warehouses are one of the key components of Snowflake's architecture, providing the compute power required to perform data processing tasks such as running SQL queries, performing joins, aggregations, and other data manipulations.
References:
[COF-C03] SnowPro Core Certification Exam Study Guide
SnowflakeDocumentation on Virtual Warehouses1

TheSnowpark-optimized warehouseis designed with significantly higher memory per node, making it ideal formachine learning (ML) trainingand other memory-intensive workloads. Snowpark-optimized warehouses provide the necessary computational power and memory for complex, large-scale data processing tasks.
Standard and multi-cluster warehouses do not offer the same memory advantage, while the 6XL warehouse is large but not specifically optimized for memory-intensive operations.

The search optimization service in Snowflake is designed to improve the performance of selective point lookup queries on large tables, which is ideal for scenarios where a query returns a small amount of data from a very large base table1. References: [COF-C03] SnowPro Core Certification Exam Study Guide