SnowflakeSnowflake
COF-C02 · Question #365
COF-C02 Question #365: Real Exam Question with Answer & Explanation
The correct answer is C: Joins information outside the object with the flattened data. The LATERAL modifier for the FLATTEN function allows joining information outside the object (such as other columns in the source table) with the flattened data, creating a lateral view that correlates with the preceding tables in the FROM clause.
Data Transformations
Question
What does the LATERAL modifier for the FLATTEN function do?
Options
- ACasts the values of the flattened data
- BExtracts the path of the flattened data
- CJoins information outside the object with the flattened data
- DRetrieves a single instance of a repeating element in the flattened data
Explanation
The LATERAL modifier for the FLATTEN function allows joining information outside the object (such as other columns in the source table) with the flattened data, creating a lateral view that correlates with the preceding tables in the FROM clause.
Topics
#FLATTEN function#LATERAL modifier#Semi-structured data#Data transformation
Community Discussion
No community discussion yet for this question.