SOL-C01 Question #97: Real Exam Question with Answer & Explanation

Question

You are loading JSON data into Snowflake. The JSON data contains nested arrays and objects. You need to flatten specific arrays while retaining other nested structures for analysis. Which combination of Snowflake functions and clauses would best achieve this?

Options

• AUse FLATTEN' function with 'RECURSIVE = TRUE to flatten all nested structures indiscriminately.
• BUse `LATERAL FLATTEN' function with `PATH' parameter to specify the array to be flattened, and
• CUse `GET PATH' to extract specific elements from the JSON and load them directly into separate
• DUse only FLATTEN' function without specifying 'PATH' and then use 'RECURSIVE = FALSE
• EUtilize `LATERAL FLATTEN' function with the 'PATH' parameter to target specific arrays for

Explanation

Using 'LATERAL FLATTEN' with the 'PATH' parameter allows you to selectively flatten specific arrays within the JSON data while retaining other nested structures. After flattening, standard SQL queries are used to process the flattened data. 'OBJECT CONSTRUCT can be used later to reconstruct nested object in views if necessary.

No community discussion yet for this question.