Answer: SAMPLE

The SAMPLE command in Snowflake is specifically designed to retrieve a random subset of rows from a table, which directly matches the question's requirement. The community discussion shows 100% consensus on option D, with multiple users confirming it as correct and referencing the official Snowflake documentation that documents the SAMPLE command for this purpose. The other options are incorrect: GENERATOR is used for generating sequences of data, LATERAL is for joining with table functions, and PIVOT is for transforming rows into columns.

Author: LeetQuiz Editorial Team