SnowPro Core Certification — Question 1152

A query is using more credits than expected. The Query Profile shows that a majority of the query execution is spent on remote disk I/O.

How can this be prevented in the future?

Answer options

• A. Convert the virtual warehouse to Maximized mode.
• B. Increase the size of the virtual warehouse.
• C. Increase the auto suspend time in the virtual warehouse.
• D. Increase the number of clusters in the virtual warehouse.

Correct answer: B

Explanation

The correct answer is B because increasing the size of the virtual warehouse enables it to handle more data in memory, reducing the reliance on remote disk I/O. The other options may improve performance in different contexts but do not directly address the issue of excessive disk I/O caused by insufficient warehouse size.