Answer-first summary for fast verification
Answer: Time when the query processing was blocked by remote disk access.
The Remote Disk I/O statistic in Snowflake's Query Profile specifically measures the time when query processing was blocked by remote disk access. This occurs when data needs to be read from or written to Snowflake's remote cloud storage (S3, Azure Blob Storage, or Google Cloud Storage) and the data doesn't fit in the virtual warehouse's memory or local disk cache. Option C is correct based on the community consensus (100% agreement) and Snowflake documentation. Option A is incorrect as it describes result cache usage. Option B is incorrect as it refers to virtual warehouse cache. Option D is incorrect as it describes network activity between Cloud Services and virtual warehouses, not disk I/O.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What does the Remote Disk I/O metric in the Query Profile measure?
A
Time spent reading from the result cache.
B
Time spent reading from the virtual warehouse cache.
C
Time when the query processing was blocked by remote disk access.
D
The level of network activity between the Cloud Services layer and the virtual warehouse.
No comments yet.