Snowflake
ADA-C01 · Question #50
ADA-C01 Question #50: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
Question
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?
Options
- Aselect * from LINEITEM sample bernoulli (20);
- Bselect * from LINEITEM sample system (20);
- Cselect * from LINEITEM tablesample block (20 rows);
- Dselect * from LINEITEM tablesample system (20) seed (1);
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.