New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ADA-C01 Exam - Topic 1 Question 48 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 48
Topic #: 1
[All ADA-C01 Questions]

An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.

What select command will generate a sample of 20% of the table?

Show Suggested Answer Hide Answer
Suggested Answer: B

This command will generate a sample of 20% of the table by using the SYSTEM (or BLOCK) sampling method, which selects each block of rows with a probability of 20/100. This method is suitable for taking data by blocks of rows, as the question requires. According to theSnowflake documentation, ''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.'' The other options are either incorrect or do not meet the requirements of the question. Option A uses the BERNOULLI (or ROW) sampling method, which selects each row with a probability of 20/100, but does not take data by blocks of rows. Option C uses the BLOCK sampling method, but specifies a fixed number of rows (20) instead of a percentage (20%). Option D uses the SYSTEM sampling method, but specifies a seed value (1), which makes the sampling repeatable, contrary to the question.


by Terry at Jan 27, 2026, 09:48 AM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Alyce
4 days ago
I remember practicing a question like this where we had to use a random sampling method. Maybe we can use TABLESAMPLE?
upvoted 0 times
...
Lenny
10 days ago
I think we need to use the SAMPLE clause, but I'm not sure how to specify the percentage correctly.
upvoted 0 times
...
Margart
15 days ago
Nice, the TABLESAMPLE clause is exactly what I was thinking. I'll make sure to specify the SYSTEM option to get the non-repeatable sample.
upvoted 0 times
...
Trinidad
20 days ago
I'm going to try using the TABLESAMPLE clause with the BERNOULLI method. That should give me a 20% sample without repeating.
upvoted 0 times
...
Nan
25 days ago
I'm a bit confused on the "not repeatable" part. Does that mean I can't use a random sampling function?
upvoted 0 times
...
Chantell
1 month ago
Okay, I think I know how to do this. I'll need to use a sampling function that takes the data by blocks of rows.
upvoted 0 times
...
Aliza
1 month ago
Hmm, this looks like a tricky one. I'll need to think carefully about how to approach this.
upvoted 0 times
...

Save Cancel