SnowPro Core Certification — Question 729

What does the “percentage scanned from cache” represent in the Query Profile?

Answer options

• A. The percentage of data scanned from the query cache
• B. The percentage of data scanned from the result cache
• C. The percentage of data scanned from the remote disk cache
• D. The percentage of data scanned from the local disk cache

Correct answer: D

Explanation

The correct answer is D, as it specifically refers to the percentage of data that is scanned from the local disk cache during query execution. Options A, B, and C are incorrect because they refer to different types of caches that do not pertain to the local disk cache.