What are common issues found by using the Query Profile? (Choose two.)
What are common issues found by using the Query Profile? (Choose two.)
The two common issues found using the Query Profile are identifying inefficient micro-partition pruning and data spilling to a local or remote disk. Inefficient micro-partition pruning can lead to slower query performance due to unnecessary data scanning, while data spilling to disk occurs when there is insufficient memory, which affects query performance and execution time.
https://docs.snowflake.com/en/user-guide/ui-query-profile.html#statistics
I think DE
DE :: https://docs.snowflake.com/en/user-guide/ui-query-profile.html#common-query-problems-identified-by-query-profile
DE are correct
If the local disk space is not sufficient, the spilled data is then saved to remote disks. Inefficient Pruning