SnowPro Core Certification — Question 747

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: B, E

Explanation

Snowflake supports uncorrelated scalar subqueries in any position where a value expression can appear, making option B correct. Additionally, EXISTS, ANY / ALL, and IN subqueries can be either correlated or uncorrelated, which aligns with option E. The other options are incorrect because they restrict the types of subqueries or their correlation status improperly.