SNOWFLAKE · objective · 14% of the exam
Monitor and optimize performance
Exam objectives are the official skill domains SnowPro® Core Certification tests. Below are the official SNOWFLAKE docs our questions on this objective cite — review them, then practise.
Sign in to track your progress on this objective.
Official references for this objective
-
Snowflake — GET_QUERY_OPERATOR_STATS | Snowflake Documentation
you can use this function to identify joins that have more output rows than input rows, which can be a sign of an “exploding” join
-
Snowflake — Monitor query activity with Query History | Snowflake Documentation
Pruning — information on the effects of table pruning: Partitions scanned — number of partitions scanned so far. Partitions total — total number of partitions
-
Snowflake — QUERY_HISTORY view | Snowflake Documentation
percentage_scanned_from_cache FLOAT Percentage of data scanned from the local disk cache. The value ranges from 0.0 to 1.0. Multiply by 100 to get a true
-
Snowflake — Using the Query Acceleration Service (QAS) | Snowflake Documentation
If the query is eligible for query acceleration, the function returns the estimated query execution time for different query acceleration scale factors
-
Snowflake — AGGREGATE_QUERY_HISTORY view | Snowflake Documentation
QUEUED_OVERLOAD_TIME OBJECT Time (in milliseconds) spent in the warehouse queue, due to the warehouse being overloaded by the current query workload.
-
Snowflake — SYSTEM$CLUSTERING_INFORMATION | Snowflake Documentation
The higher the number, the more micro-partitions can be pruned from queries executed on the table, which has a corresponding impact on performance.
-
Snowflake — Exploring execution times | Snowflake Documentation
select Monitoring » Query History . Use the Duration column to understand how long it took a query to execute. You can sort the column
-
Snowflake — Multi-cluster warehouses | Snowflake Documentation
You can also see the cluster used to execute each statement that the warehouse processed. To choose which details to view, select the items such
-
Snowflake — Optimizing query performance | Snowflake Documentation
Optimization Storage cost Compute cost Search optimization service ✔ ✔ Query acceleration service ✔ Materialized view ✔ ✔ Clustering the table ✔
-
Snowflake — Optimizing the warehouse cache | Snowflake Documentation
provides the percentage of data scanned from cache, aggregated across all queries and broken out by warehouse