Snowflake Exam SnowPro-Core Topic 7 Question 83 Discussion

Actual exam question for Snowflake's SnowPro Core Exam exam

Question #: 83
Topic #: 7

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

ABytes spilled to local cache.

BBytes spilled to local storage.

CBytes spilled to remote cache.

DBytes spilled to remote storage.

EBytes spilled to remote metastore.

Show Suggested Answer

Suggested Answer: B, D

by Rima at Mar 16, 2024, 09:46 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 days ago

I agree with Bytes spilled to local storage is a clear sign of a query being too large for memory.

upvoted 0 times

...

2 days ago

I think if the query spills a large amount of bytes to local storage, it indicates it's too large for memory.

upvoted 0 times

...