Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 599

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

select * from gold_data tablesample (100);

    Correct Answer: C

    The TABLESAMPLE clause with a parameter of (100) indicates that the query will return a sample comprising 100% of the rows from the gold_data table. Thus, the result will be the entire table.

Discussion
RenvisOption: C

c is the answer. "100 Rows" will return 100 rows. 100 is the probability. so all columns will be returned.

bar_serOption: C

Correct answer is : C https://docs.snowflake.com/en/sql-reference/constructs/sample Return an entire table, including all rows in the table: SELECT * FROM testtable TABLESAMPLE (100);

bibisaOption: C

The TABLESAMPLE clause in the query specifies that the result set should contain a random sample of data from the table, with the percentage specified as 100. This means that the entire table will be included in the result set, but the order of the rows will be random.

bibisaOption: C

from doc: Return an entire table, including all rows in the table: SELECT * FROM testtable TABLESAMPLE (100);

muks86Option: C

Correct :C,https://docs.snowflake.com/en/sql-reference/constructs/sampleReturn an entire table, including all rows in the table: SELECT * FROM testtable TABLESAMPLE (100);

dementorOption: C

C is the correct answer

Ram9198Option: C

It is the percentage of rows from table 100 means 100 percent so full table

jtm22Option: C

https://docs.snowflake.com/en/sql-reference/constructs/sample

MultiCloudIronManOption: B

num specifies the number of rows (up to 1,000,000) to sample from the table. Can be any integer between 0 (no rows selected) and 1000000 inclusive.