Snowflake Exam SnowPro-Core Topic 7 Question 83 Discussion

Actual exam question for Snowflake's SnowPro-Core exam

Question #: 83
Topic #: 7

[All SnowPro-Core Questions]

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

Get Premium SnowPro-Core Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Trina

6 months ago

I believe bytes spilled to local cache is also an indicator of a query being too large to fit in memory.

upvoted 0 times

...

Ciara

6 months ago

I agree with Denise. Bytes spilled to remote storage could also signal the query is too big.

upvoted 0 times

...

Denise

6 months ago

I think if we see a lot of bytes spilled to local storage, that could indicate the query is too large.

upvoted 0 times

...

Gracia

7 months ago

Yes, that makes sense. If it has to spill to local and remote storage, it's definitely too large for memory.

upvoted 0 times

...

Misty

7 months ago

I also think that if the query spills a large amount of bytes to both local storage and remote storage, it definitely can't fit in memory.

upvoted 0 times

...

Venita

8 months ago

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

upvoted 0 times

...

Gracia

8 months 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

...