SnowPro Core Certification — Question 110

The FLATTEN function is used to query which type of data in Snowflake?

Answer options

• A. Structured data
• B. Semi-structured data
• C. Both of the above
• D. None of the above

Correct answer: C

Explanation

The FLATTEN function in Snowflake is designed to work with both structured and semi-structured data, allowing users to query nested data formats effectively. Option A is incorrect because it limits the function to only structured data, while Option B is also incorrect for the same reason. Therefore, the correct answer is C, as it encompasses both types of data.