COF-C02 · Question #620
COF-C02 Question #620: Real Exam Question with Answer & Explanation
The correct answer is D: CONNECT BY. In Snowflake, the CONNECT BY clause allows users to perform recursive queries. Recursive queries are used to process hierarchical or tree-structured data, such as organizational charts or file systems. The CONNECT BY clause is used in conjunction with the START WITH clause to spe
Question
In Snowflake, what allows users to perform recursive queries?
Options
- AQUALIFY
- BLATERAL
- CPIVOT
- DCONNECT BY
Explanation
In Snowflake, the CONNECT BY clause allows users to perform recursive queries. Recursive queries are used to process hierarchical or tree-structured data, such as organizational charts or file systems. The CONNECT BY clause is used in conjunction with the START WITH clause to specify the starting point of the hierarchy and the relationship between parent and child rows.
Topics
Community Discussion
No community discussion yet for this question.