Answer: The percentage of data scanned from the local disk cache

The 'percentage scanned from cache' metric in Snowflake's Query Profile specifically refers to the percentage of data scanned from the local disk cache. This is clearly documented in Snowflake's official documentation and confirmed by the community discussion where multiple users with upvotes reference the documentation stating this exact definition. Option D is correct because it accurately describes the local disk cache, which stores frequently accessed data from cloud storage for faster retrieval. Option A (query cache) is incorrect as query caching is handled differently and would show as 'QUERY RESULT REUSE'. Option B (result cache) is also incorrect for the same reason. Option C (remote disk cache) is not a standard Snowflake term and doesn't align with the documented definition.

Author: LeetQuiz Editorial Team