Snowpro Core · Free Practice Question Easy
Question 31
The FLATTEN function in Snowflake must be explicitly joined using a LATERAL keyword in queries.
-
A
False
-
B
True
Reveal correct answer
Correct answer: A
A.
The FLATTEN function in Snowflake implicitly creates a lateral join when used in the FROM clause. It does not require the explicit use of the LATERAL keyword, though it can be used explicitly if desired.
B.
This is incorrect because the FLATTEN function performs an implicit lateral join, and using the LATERAL keyword is optional, not mandatory.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
