SnowPro Core Certification — Question 156

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Answer options

Correct answer: B, D

Explanation

The correct answer includes B (PATH) and D (INDEX) because these columns are specifically part of the output when using the LATERAL FLATTEN function in Snowflake. The other options, while related to data handling, do not appear in the result set of this command.