SnowPro Core Certification — Question 458

What will be the output of the below query against the table name gold_data?

select * from gold_data tablesample (100);

Answer options

• A. It will return an empty sample.
• B. It will return a random 100 rows.
• C. It will return an entire table.
• D. It will produce an error message.

Correct answer: C

Explanation

The correct answer is C because the TABLESAMPLE clause is used to return a sample of rows from a table, and in this case, specifying 100 indicates that the entire table will be returned. The other options are incorrect as they suggest either an error or a sample that does not reflect the entire dataset.