Exam COF-C03 Topic 1 Question 789 Discussion

The correct answer is B. SELECT * FROM table_A TABLESAMPLE (100); .
TABLESAMPLE (100) samples 100 percent of the table, so it returns all rows from table_A.
Why B is correct:
SELECT *
FROM table_A TABLESAMPLE (100);
This requests a 100 percent sample, which is effectively the full table.
Why the other options are incorrect:
A). TABLESAMPLE (0) returns 0 percent of the table, not all rows.
C). SAMPLE (10) returns approximately 10 percent of the rows, not all rows.
D). TABLESAMPLE BERNOULLI (10) samples each row with a 10 percent probability, not all rows.
Official Snowflake documentation reference:
Snowflake documentation explains that SAMPLE / TABLESAMPLE can specify a probability percentage. A value of 100 represents 100 percent of the table.
Reference: Snowflake Documentation - SAMPLE / TABLESAMPLE; SnowPro Core Study Guide - SQL and Snowflake Objects.
==