Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Go to Exam

Exam SnowPro Core topic 1 question 711 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 711
Topic #: 1

[All SnowPro Core Questions]

What aspect of an executed query is represented by the remote disk I/O statistic of the Query Profile in Snowflake?

A. Time spent scanning the table partitions to filter data based on the predicate
B. Time spent caching the data to remote storage in order to buffer the data being extracted and exported
C. Time spent reading and writing data from and to remote storage when the data being accessed does not fit into the executing virtual warehouse node memory
D. Time spent reading and writing data from and to remote storage when the data being accessed does not fit into either the virtual warehouse memory or the local disk

Show Suggested Answer

Suggested Answer: D 🗳️

by MultiCloudIronMan at July 15, 2023, 9:08 p.m.

Comments

Submit Cancel

0e504b5

11 months, 3 weeks ago

Selected Answer: A

I think the correct answer is A B - not correct C - the correct metric for that would be Bytes spilled to local storage D - the correct metric for that would be Bytes spilled to remote storage A - correct, we're accessing the remote disk (the Storage Layer) to retrieve the data for the query. https://community.snowflake.com/s/article/Performance-impact-from-local-and-remote-disk-spilling https://community.snowflake.com/s/article/Performance-impact-from-local-and-remote-disk-spilling https://community.snowflake.com/s/article/Performance-impact-from-local-and-remote-disk-spilling

upvoted 1 times

0e504b5

11 months, 3 weeks ago

Correction: C wouldn't happen the way it's described in the question. In case with C, data will be written to local storage (of the warehouse)

upvoted 1 times

0e504b5

11 months, 3 weeks ago

Changing my mind to B. We can cross-reference the options against this doc: https://docs.snowflake.com/en/user-guide/ui-query-profile#statistics A - Pruning B - IO C - Spilling D- Spilling

upvoted 1 times

0e504b5

11 months, 3 weeks ago

I just ran a couple of sample queries and I change my mind back to option A. Remote disk I/O means we're accessing the data from the storage layer.

upvoted 1 times

0e504b5

11 months, 3 weeks ago

If you run a query, look for it in the Activity History, click on TableScan, you will see that most of that may be Remote Disk I/O (option A)

upvoted 1 times

...

kayuhanbiduk

1 year, 3 months ago

Selected Answer: C

agree with rajukg

upvoted 1 times

...

rajukg

1 year, 4 months ago

"local disk" is remote storage, with respect to warehouse memory. So, I feel C is correct.

upvoted 2 times

...

VipinSingla

1 year, 5 months ago

Selected Answer: D

C would assume writing to local disk is also "remote disk IO" which doesn't seem to be the case

upvoted 3 times

...

ukpino

1 year, 6 months ago

Selected Answer: D

I think it's D C would assume writing to local disk is also "remote disk IO" which doesn't seem to be the case

upvoted 4 times

MultiCloudIronMan

1 year, 6 months ago

I agree its D

upvoted 1 times

...

MultiCloudIronMan

1 year, 6 months ago

Selected Answer: C

https://www.bing.com/search?q=What+aspect+of+an+executed+query+is+represented+by+the+remote+disk+I%2FO+statistic+of+the+Query+Profile+in+Snowflake%3F&qs=n&form=QBRE&sp=-1&lq=1&pq=what+aspect+of+an+executed+query+is+represented+by+the+remote+disk+i%2Fo+statistic+of+the+query+profile+in+snowflake%3F&sc=1-115&sk=&cvid=162E812CC7634C82884FFC2F70CA9AD9&ghsh=0&ghacc=0&ghpl=

upvoted 1 times

MultiCloudIronMan

1 year, 6 months ago

Changing to D based on points by Ukpino

upvoted 1 times

...