SnowPro Core Certification — Question 992

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

Answer options

• A. FLATTEN
• B. GET_PATH
• C. CHECK_JSON
• D. PARSE_JSON

Correct answer: A

Explanation

The correct answer is A, FLATTEN, which is specifically designed to handle nested structures and extract distinct keys. The other options, while useful for different tasks, do not provide the functionality to return a list of unique key names across all nested elements.