SnowPro Core Certification — Question 1037

In Snowflake, what allows users to perform recursive queries?

Answer options

• A. QUALIFY
• B. LATERAL
• C. PIVOT
• D. CONNECT BY

Correct answer: D

Explanation

The correct answer is D, CONNECT BY, which is specifically designed for recursive queries in SQL. The other options, such as QUALIFY, LATERAL, and PIVOT, serve different purposes and do not facilitate recursive querying in Snowflake.