SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ96

Performance, Cost, and Resource Optimization

An Architect is examining a performance issue in an existing architecture and identifies a query whose Query Profile shows a high number of bytes spilled to remote storage. The query contains a WHERE clause that filters out a high percentage of records.

What actions can reduce remote-storage spillage and improve query performance?

Choose two
Explanation

A larger virtual warehouse supplies more memory and local storage capacity, reducing the need to spill intermediate data to remote storage. A clustering key on columns used in highly selective filters improves micro-partition pruning, so fewer rows and partitions are scanned and processed. Snowflake recommends larger warehouses for remote spillage and recommends clustering columns actively used in selective filters.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!