COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ98

Performance Optimization, Querying & Transformation

Which actions can reduce memory spilling for queries that are too large to fit in memory?

Choose two
Explanation

Snowflake recommends using a larger virtual warehouse to increase memory and local-storage capacity for the operation, or rewriting the workload to process data in smaller batches. Additional warehouse clusters primarily improve concurrent workload capacity, not the memory available to an individual query.

Learn more

Community Discussion

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