SnowPro Core Certification — Question 1174

What does the Remote Disk I/O statistic in the Query Profile indicate?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because the Remote Disk I/O statistic specifically measures the time when the query's performance was impeded due to accessing data on remote disks. Options A and B refer to cache reads, which are not related to disk I/O, while option D discusses network activity but does not directly address the concept of remote disk access.