Deal of The Day! 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

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?
B) select * from LINEITEM sample system (20);
C) select * from LINEITEM tablesample block (20 rows);
D) select * from LINEITEM tablesample system (20) seed (1);
A) select * from LINEITEM sample bernoulli (20);

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
Samira
2 days ago
We could also try using OFFSET and FETCH for more control.
upvoted 0 times
...
Sylvia
7 days ago
But is that really non-repeatable?
upvoted 0 times
...
Beckie
13 days ago
Yeah, something like "SELECT * FROM LINEITEM TABLESAMPLE SYSTEM (20)".
upvoted 0 times
...
Renea
18 days ago
I think we need to use the TABLESAMPLE clause.
upvoted 0 times
...
Leana
2 months ago
Wait, does that really give a non-repeatable sample?
upvoted 0 times
...
Barbra
2 months ago
I agree with Justine, that’s the standard way!
upvoted 0 times
...
Shaniqua
2 months ago
I think it should be TABLESAMPLE BERNOULLI instead.
upvoted 0 times
...
Jaime
3 months ago
Sounds right, but isn't that just for certain databases?
upvoted 0 times
...
Justine
3 months ago
You can use TABLESAMPLE SYSTEM (20).
upvoted 0 times
...
Ronald
3 months ago
This question is making me hungry. Anyone else craving a nice juicy steak sample?
upvoted 0 times
...
Annabelle
3 months ago
Hmm, I wonder if there's a way to make the sample repeatable. You know, for those of us who like to live on the edge.
upvoted 0 times
...
Ilene
3 months ago
I'd use the TABLESAMPLE clause for this. Seems like the most straightforward way to get a random sample.
upvoted 0 times
...
Janella
3 months ago
20% is a good sample size. Wouldn't want to go overboard and sample the whole table, that's just showing off.
upvoted 0 times
...
Rolande
4 months ago
The sampling function should definitely take the data by blocks of rows. Anything else would just be weird.
upvoted 0 times
...
Janna
4 months ago
I definitely remember that the sample should be non-repeatable, so we might need to use a different approach than just a simple SELECT statement.
upvoted 0 times
...
Lilli
4 months ago
I feel like the command should include something like "TABLESAMPLE SYSTEM (20)" but I can't recall the exact syntax.
upvoted 0 times
...
Alyce
5 months 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
5 months 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
5 months 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
5 months 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
5 months 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
6 months 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
6 months ago
Hmm, this looks like a tricky one. I'll need to think carefully about how to approach this.
upvoted 0 times
...

Save Cancel