SnowPro Core Recertification — Question 5

Which types of subqueries does Snowflake support? (Choose two.)

Answer options

• 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

Correct answer: A, B

Explanation

The correct answers are A and B because Snowflake allows uncorrelated scalar subqueries in both WHERE clauses and any context that accepts value expressions. Options C, D, and E are incorrect because they focus on EXISTS, ANY / ALL, and IN subqueries in a way that does not align with Snowflake's support for uncorrelated subqueries.