SnowPro Core Certification — Question 210

What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)

Answer options

• A. KEY
• B. NODE
• C. VALUE
• D. LEVEL
• E. ROOT

Correct answer: A, C

Explanation

The FLATTEN command in semi-structured data returns the KEY and VALUE columns. KEY represents the identifier for each element, while VALUE contains the actual data content. The other options, NODE, LEVEL, and ROOT, are not part of the output for this command.