SnowPro Core Certification — Question 589

Which Snowflake SQL command is used to get a subset of rows randomly from a table?

Answer options

• A. GENERATOR
• B. LATERAL
• C. PIVOT
• D. SAMPLE

Correct answer: D

Explanation

The correct answer is D. SAMPLE, which is specifically designed to return a random subset of rows from a table. Options A (GENERATOR), B (LATERAL), and C (PIVOT) serve different purposes in SQL and do not provide functionality for randomly selecting rows.