SnowPro Core Certification — Question 542

Which command would return an empty sample?

Answer options

• A. select * from testtable sample ();
• B. select * from testtable sample (0);
• C. select * from testtable sample (null);
• D. select * from testtable sample (none);

Correct answer: B

Explanation

The correct answer is B because using 'sample (0)' specifies that no rows should be returned from the testtable. The other options either do not specify a valid sampling size (A, C, and D) or indicate a non-zero sample size, which would result in returning rows.