Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 599 discussion

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

What will be the output of the below query against the table name gold_data?

select * from gold_data tablesample (100);

  • A. It will return an empty sample.
  • B. It will return a random 100 rows.
  • C. It will return an entire table.
  • D. It will produce an error message.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Renvis at Feb. 14, 2023, 2:26 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Renvis
Highly Voted 1 year, 9 months ago
c is the answer. "100 Rows" will return 100 rows. 100 is the probability. so all columns will be returned.
upvoted 10 times
...
bar_ser
Highly Voted 1 year, 9 months ago
Correct answer is : C https://docs.snowflake.com/en/sql-reference/constructs/sample Return an entire table, including all rows in the table: SELECT * FROM testtable TABLESAMPLE (100);
upvoted 7 times
...
Mitchdu
Most Recent 3 months, 3 weeks ago
Selected Answer: C
Sample keyword can be used in two ways: 100 = 100% probability, all rows 100 ROWS = only 100 rows returned
upvoted 1 times
...
[Removed]
1 year ago
Selected Answer: C
It is the percentage of rows from table 100 means 100 percent so full table
upvoted 1 times
...
bibisa
1 year, 7 months ago
The TABLESAMPLE clause in the query specifies that the result set should contain a random sample of data from the table, with the percentage specified as 100. This means that the entire table will be included in the result set, but the order of the rows will be random.
upvoted 4 times
...
jtm22
1 year, 7 months ago
Selected Answer: C
https://docs.snowflake.com/en/sql-reference/constructs/sample
upvoted 1 times
...
bibisa
1 year, 8 months ago
Selected Answer: C
from doc: Return an entire table, including all rows in the table: SELECT * FROM testtable TABLESAMPLE (100);
upvoted 4 times
...
dementor
1 year, 8 months ago
Selected Answer: C
C is the correct answer
upvoted 2 times
...
MultiCloudIronMan
1 year, 9 months ago
Selected Answer: B
num specifies the number of rows (up to 1,000,000) to sample from the table. Can be any integer between 0 (no rows selected) and 1000000 inclusive.
upvoted 1 times
...
muks86
1 year, 9 months ago
Correct :C,https://docs.snowflake.com/en/sql-reference/constructs/sampleReturn an entire table, including all rows in the table: SELECT * FROM testtable TABLESAMPLE (100);
upvoted 4 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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