ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 905 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 905
Topic #: 1
[All SnowPro Core Questions]

How can a Snowflake user sample 10 rows from a table named SNOWPRO? (Choose two.)

  • A. SELECT * FROM SNOWPRO SAMPLE SYSTEM (10)
  • B. SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS)
  • C. SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10)
  • D. SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10 ROWS)
  • E. SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS)
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️
by Heetec at Oct. 27, 2023, 10:10 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
0e504b5
8 months, 4 weeks ago
Selected Answer: BE
SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER; --60 -- A - not correct -- showing different results each time -- 5, 8, 7 SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE SYSTEM (10); -- B - correct --10 SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE (10 ROWS); -- C - not correct --9,6,11 SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE BLOCK (10); -- D - not working --Sampling with a fixed size does not support using block sampling method. SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE BLOCK (10 ROWS); -- E - correct -- 10 SELECT COUNT(*) FROM SNOWFLAKE_SAMPLE_DATA.TPCDS_SF100TCL.CALL_CENTER TABLESAMPLE BERNOULLI (10 ROWS);
upvoted 3 times
0e504b5
8 months, 4 weeks ago
BERNOULLI | ROW or SYSTEM | BLOCK Specifies the sampling method to use: BERNOULLI (or ROW): Includes each row with a probability of p/100. Similar to flipping a weighted coin for each row. SYSTEM (or BLOCK): Includes each block of rows with a probability of p/100. Similar to flipping a weighted coin for each block of rows. This method does not support fixed-size sampling. https://docs.snowflake.com/en/sql-reference/constructs/sample
upvoted 2 times
...
...
gizzamo
10 months, 2 weeks ago
Selected Answer: BE
B and E are correct. https://docs.snowflake.com/en/sql-reference/constructs/sample#fixed-size-row-sampling
upvoted 3 times
...
Bhargava12
11 months, 3 weeks ago
Selected Answer: BE
SELECT * FROM SNOWPRO TABLESAMPLE (10 ROWS) SELECT * FROM SNOWPRO SAMPLE BERNOULLI (10 ROWS) BE give 10 rows
upvoted 3 times
...
BobFar
1 year ago
BE is the correct answer. System or Block do not support fixed rows. https://docs.snowflake.com/en/sql-reference/constructs/sample#:~:text=BERNOULLI%20%7C%20ROW%20or%20SYSTEM%20%7C%20BLOCK
upvoted 4 times
BobFar
1 year ago
I checked 1- " SELECT * FROM SNOWPRO TABLESAMPLE BLOCK (10 ROWS)" 2- " SELECT * FROM SNOWPRO TABLESAMPLE SYSTEM (10 ROWS)" and got below error! Sampling with a fixed size does not support using block sampling method. BE is correct.
upvoted 3 times
...
...
Heetec
1 year ago
Selected Answer: BD
BD correct
upvoted 1 times
BobFar
1 year ago
System or Block do not support fixed rows.
upvoted 3 times
Heetec
1 year ago
thanks for correction :)
upvoted 2 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago