nerdexam
Snowflake

COF-C02 · Question #76

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

The correct answer is B. 8. In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a size Small virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and…

Snowflake Cloud Data Platform Features and Architecture

Question

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Exhibit

COF-C02 question #76 exhibit

Options

  • A4
  • B8
  • C16
  • D32

How the community answered

(20 responses)
  • B
    90% (18)
  • C
    5% (1)
  • D
    5% (1)

Explanation

In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a size Small virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and 8 for Large). Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Topics

#Virtual Warehouse#Warehouse Sizing#Compute Resources#Snowflake Architecture

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice