SnowPro Core Certification — Question 449

What is a responsibility of Snowflake’s virtual warehouses?

Answer options

• A. Infrastructure management
• B. Metadata management
• C. Query execution
• D. Query parsing and optimization
• E. Permanent storage of micro-partitions

Correct answer: C

Explanation

The correct answer is C because Snowflake's virtual warehouses are primarily responsible for executing queries. Options A and B involve other components of the Snowflake architecture, while D pertains to the initial stages of query handling, and E refers to the storage aspect, which is not managed by virtual warehouses.