Explanation:
The question requires selecting two methods to sample exactly 10 rows from the SNOWPRO table. Based on Snowflake documentation and community consensus with high upvotes, fixed-size row sampling (specifying 'ROWS') is only supported with BERNOULLI (or ROW) sampling method. Option B (TABLESAMPLE (10 ROWS)) uses the default BERNOULLI method and returns exactly 10 rows. Option E (SAMPLE BERNOULLI (10 ROWS)) explicitly uses BERNOULLI sampling and returns exactly 10 rows. Options A and C use SYSTEM/BLOCK sampling with percentage-based sampling (10%), which returns variable row counts, not fixed 10 rows. Option D explicitly tries BLOCK sampling with fixed rows, which Snowflake documentation confirms is unsupported and throws an error. The community discussion shows multiple users testing these options and confirming B and E consistently return 10 rows while others either return variable counts or fail.
Ultimate access to all questions.
No comments yet.
Which two methods can a Snowflake user employ to sample 10 rows from a table named SNOWPRO?
A
SELECT * FROM SNOWPRO SAMPLE SYSTEM (10)
B
SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS)
C
SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10)
D
SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10 ROWS)
E
SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS)