Answer: CONNECT BY

The question asks which feature in Snowflake enables recursive queries. CONNECT BY is Snowflake's implementation for hierarchical queries, which includes recursive capabilities for traversing tree-like data structures. The community discussion shows 100% consensus on answer D (CONNECT BY), with a reference to Snowflake's official documentation confirming this functionality. QUALIFY is used for filtering window functions, LATERAL is for joining with table-valued functions, and PIVOT is for transforming rows into columns - none of these support recursive operations.

Author: LeetQuiz Editorial Team