What will occur if a virtual warehouse size is increased from Small to Medium?

The correct answer is D. The compute capacity will be doubled.. Snowflake virtual warehouse sizes follow a doubling pattern at each tier (XS → S → M → L → XL → 2XL, etc.). Moving from Small to Medium doubles the number of compute servers in the cluster, which doubles both the credit consumption per hour and the raw compute capacity available

Virtual Warehouses

Question

Options

AQuery scheduling will be optimized.
BAdditional user roles will be available in the warehouse.
CAdditional micro-partitions will be created in the warehouse.
DThe compute capacity will be doubled.

How the community answered

(28 responses)

A
4% (1)
C
7% (2)
D
89% (25)

Explanation

Snowflake virtual warehouse sizes follow a doubling pattern at each tier (XS → S → M → L → XL → 2XL, etc.). Moving from Small to Medium doubles the number of compute servers in the cluster, which doubles both the credit consumption per hour and the raw compute capacity available to process queries. This does not affect query scheduling logic (A), user roles (B), or micro-partition creation (C), which are entirely separate Snowflake concepts.

Topics

#Virtual Warehouses#Warehouse Scaling#Compute Capacity#Performance Tuning

Community Discussion

No community discussion yet for this question.

Full SOL-C01 Practice