SnowPro Core Certification — Question 1287

What would cause different results to be returned when running the same query twice?

Answer options

• A. SAMPLE is used and the seed is set.
• B. SAMPLE is used and the seed is not set.
• C. Fraction-based sampling is used.
• D. Fixed-size sampling is used.

Correct answer: B

Explanation

The correct answer is B because when SAMPLE is used without setting a seed, it introduces randomness, resulting in different results on each execution. In contrast, option A would produce consistent results since the seed is set. Options C and D refer to different types of sampling methods, which do not inherently create variability like the lack of a seed does.