Snowpro Core · Free Practice Question Medium
Question 3
Which of these Sampling methods does Snowflake support? (Select 2)
- A Sample a fraction of the table with a specified probability of including a given row
- B Sample a fixed, specified number of rows
- C Sample exact rows of the table with the specified sequence keys
Reveal correct answers
Correct answers: A, B
Explanation
SAMPLE / TABLESAMPLE returns a subset of rows sampled randomly from the specified table. The following sampling methods are supported: Sample a fraction of a table, with a specified probability for including a given row. The number of rows returned depends on the size of the table and the requested probability. A seed can be specified to make the sampling deterministic. Sample a fixed, specified number of rows. The exact number of specified rows is returned unless the table contains fewer rows. SAMPLE and TABLESAMPLE are synonymous and can be used interchangeably.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
