Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 837

Which query will return a sample of a table with 1000 rows named testtable, in which each row has a 10% probability of being included in the sample?

select * from testtable sample (0.1);

select * from testtable sample (10);

select * from testtable sample (0.1 rows);

select * from testtable sample (10 rows);

Correct Answer: A

To return a sample of a table in which each row has a 10% probability of being included, the correct query is 'select * from testtable sample (0.1);'. This syntax specifies the percentage (10%) as a decimal fraction (0.1).

Discussion

kayuhanbidukOption: B

B for 10%

HeetecOption: B

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