Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Given a table named MY_TABLE containing 10 rows, which of the following sampling queries is guaranteed to return exactly 5 rows?_
A
SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);*_
B
SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);*_
C
SELECT * FROM MY_TABLE SAMPLE (5 ROWS);*_
D
SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);*_