SnowPro Core Certification — Question 697
What aspect of an executed query is represented by the remote disk I/O statistic of the Query Profile in Snowflake?
Answer options
- 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
Correct answer: D
Explanation
The correct answer is D because it accurately describes the situation where data access requires reading and writing to remote storage due to limitations in both virtual warehouse memory and local disk. Option A refers to scanning time, Option B is about caching data, and Option C addresses only the virtual warehouse memory, omitting the local disk aspect.