SnowPro Core Certification — Question 855

What is used during the FIRST execution of SELECT COUNT(*) FROM ORDER?

Answer options

• A. Remote disk cache
• B. Virtual warehouse cache
• C. Cache result
• D. Metadata-based result

Correct answer: D

Explanation

The correct answer is D, as metadata-based results provide the necessary information about the structure of the data without needing to scan the entire dataset. The other options, such as remote disk cache, virtual warehouse cache, and cache result, are not specifically utilized for the initial execution of this query.