SnowPro Core Certification — Question 876

How can a Snowflake user sample 10 rows from a table named SNOWPRO? (Choose two.)

Answer options

• 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)

Correct answer: B, E

Explanation

The correct options B and E utilize the TABLESAMPLE clause, which is specifically designed for sampling rows in Snowflake. Option A is incorrect as the SAMPLE SYSTEM syntax does not support specifying the number of rows directly. Options C and D reference BLOCK sampling, which does not allow for a specific row count like the TABLESAMPLE method does.