exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1224 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 1224
Topic #: 1
[All SnowPro Core Questions]

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

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
37ceea2
3 weeks, 1 day ago
Selected Answer: C
Remote Disk I/O = TIME SPENT reading and writing data from and to remote storage, when data are being accessed, does not fit into either Virtual Warehouse memory or the Local Disk. But reading and writing does not look like being blocked by remote disk access. Difficult to reply. I am selecting an answer, just for being able to post.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago