SOL-C01 practice question 29 of 30

What Snowflake parameter is configured in the Query Processing layer?

Full set: 214 questions
Answer options
A: The minimum and maximum serverless compute limits
B: The types of tables available in an account
C: The sizing of virtual warehouses Correct answer
D: The minimum and maximum micro-partition limits
Correct Answer:
C. The sizing of virtual warehouses
Explanation

The Query Processing layer in Snowflake's architecture is where queries are executed. This layer consists of virtual warehouses, which are compute clusters. A key configuration parameter for this layer is the size of the virtual warehouse (e.g., X-Small, Small, Medium), which determines the amount of compute resources allocated to execute queries and load data. Sizing directly impacts query performance and concurrency.

Why Incorrect

A. Serverless compute limits are configurations for specific features (like Snowpipe or Automatic Clustering), not a general parameter for the entire query processing layer.
B. The types of tables (e.g., Permanent, Transient) are a property of the database storage layer, defining data persistence and recovery options.
D. Micro-partition limits are managed automatically by Snowflake as part of its storage optimization and are not a user-configurable parameter.

References

- Snowflake Documentation, "Understanding the Snowflake Architecture", Section: "Query Processing". This section states, "Query execution is performed in the processing layer. Snowflake processes queries using 'virtual warehouses'."

- Snowflake Documentation, "Virtual Warehouses", Section: "Overview of Warehouses". This section details how warehouses are sized and configured by users to provide the necessary compute resources for query execution.

Scroll to Top