Domain 3.0: Snowflake Performance Concepts

This topic provides information on the performance concepts used in the snowflake

Domain 3.0: Performance Concepts
3.1 Explain the use of the Query Profile.

Explain plans
Data spilling
Use of the data cache
Micro-partition pruning
Query history

3.2. Explain virtual warehouse configurations.

Multi-clustering
Warehouse sizing
Warehouse settings and access

3.3 Outline virtual warehouse performance tools.

Monitoring warehouse loads
Query performance
Scaling up compared to scaling out
Resource monitors

3.4 Optimize query performance.

Describe the use of materialized views
Use of specific SELECT commands

#snowflakecomputing #snowflakedatawarehouse #performance