Which of the following query profiler variables will indicate that a virtual warehouse is not sized correctly for the query being executed?
Which of the following query profiler variables will indicate that a virtual warehouse is not sized correctly for the query being executed?
Remote spillage indicates that a virtual warehouse is not sized correctly because it reflects that the operation does not have enough memory to hold intermediate results, causing the query processing engine to start saving data to remote disks. This is a clear sign that the virtual warehouse needs to be resized or reconfigured to handle the workload appropriately.
D is correct
For some operations (e.g. duplicate elimination for a huge data set), the amount of memory available for the compute resources used to execute the operation might not be sufficient to hold intermediate results. As a result, the query processing engine will start spilling the data to local disk. If the local disk space is not sufficient, the spilled data is then saved to remote disks. https://docs.snowflake.com/en/user-guide/ui-query-profile
D. Remote spillage
Correct