Answer-first summary for fast verification
Answer: Uncorrelated scalar subqueries in any place that a value expression can be used, EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated
Based on the Snowflake documentation and community consensus with 100% agreement and upvoted comments, Snowflake supports: (B) Uncorrelated scalar subqueries in any place that a value expression can be used, and (E) EXISTS, ANY/ALL, and IN subqueries in WHERE clauses that can be correlated or uncorrelated. Option A is incorrect because uncorrelated scalar subqueries are not limited to WHERE clauses. Option C is incorrect because EXISTS/ANY/ALL/IN subqueries can be both correlated and uncorrelated, not just uncorrelated. Option D is incorrect because they can be both correlated and uncorrelated, not just correlated.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following subquery types are supported by Snowflake? (Select two.)
A
Uncorrelated scalar subqueries in WHERE clauses
B
Uncorrelated scalar subqueries in any place that a value expression can be used
C
EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only
D
EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated only
E
EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated