Answer-first summary for fast verification
Answer: The data is based on sampling every row.
The Bernoulli sampling method (also known as ROW sampling) in Snowflake's SAMPLE function works by including each row with a probability of p/100, where p is the specified sampling percentage. This is analogous to flipping a weighted coin for each row independently. Option A correctly describes this as 'sampling every row' with the specified probability, while the other options are incorrect: B suggests a fixed 10% sampling regardless of the actual parameter, C describes block sampling (which is SYSTEM sampling), and D suggests a fixed row count sampling (which is not Bernoulli sampling). The community discussion shows 100% consensus on A with references to Snowflake documentation confirming this behavior.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What does it mean when the SAMPLE function uses the Bernoulli sampling method?
A
The data is based on sampling every row.
B
The data is based on sampling 10% of the source data.
C
The data is based on sampling blocks of the source data.
D
The data is based on sampling 1000 rows of the source data.
No comments yet.