Explanation:
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.
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