Exam SnowPro Core topic 1 question 382 discussion

correct

C. Query execution. Snowflake's virtual warehouses are responsible for executing queries and processing data within Snowflake. They are separate from the storage layer, where the actual data is stored in micro-partitions, and the compute layer, where query execution takes place. Virtual warehouses are isolated compute resources that can be scaled up or down as needed to meet changing query performance requirements. When a query is executed, Snowflake automatically selects a virtual warehouse to run the query based on its current workload and available resources. Infrastructure management, metadata management, query parsing and optimization, and permanent storage of micro-partitions are not responsibilities of Snowflake's virtual warehouses. These tasks are performed by other components of the Snowflake architecture.