Answer-first summary for fast verification
Answer: Increase the size of the virtual warehouse.
The Query Profile showing majority time spent on remote disk I/O indicates spillage of intermediate data to cloud storage, which is inefficient and costly. Option B (Increase the size of the virtual warehouse) is correct because larger warehouses provide more RAM and local SSD cache, allowing intermediate results to stay in memory or on faster local storage rather than spilling to slower remote storage. This directly addresses the root cause of excessive remote disk I/O. Option A (Convert to Maximized mode) is not relevant as it focuses on concurrency rather than memory allocation. Option C (Increase auto suspend time) affects warehouse idle time, not memory capacity. Option D (Increase clusters) improves parallelism for concurrent queries but doesn't increase memory per query, which is needed to prevent spillage.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A query is consuming more credits than anticipated. The Query Profile indicates that the majority of the query execution time is spent on remote disk I/O.
How can this be mitigated in the future?
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.
No comments yet.