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

Question

You are inserting data into a table named 'EVENTS' which contains a column 'EVENT DATA' of type 'VARIANT'. The data being inserted comes from an external stage and is in JSON format. However, you are encountering errors because some of the JSON documents contain deeply nested arrays and objects, leading to excessive memory consumption during the INSERT operation. Which of the following actions can you take to mitigate this issue and successfully load the data using the 'INSERT' command with data from a stage? Choose TWO.

Options

• AIncrease the size of the virtual warehouse to provide more memory for the INSERT operation.
• BPre-process the JSON data outside of Snowflake to flatten or simplify the nested structures before
• CUse = TRUE file format option for the stage.
• DUse the `VALIDATE function to identify problematic JSON documents and exclude them from the
• EBreak down the INSERT operation into smaller batches, processing subsets of the data at a time.

Explanation

Options B and E are the most effective solutions. Option B, pre-processing the data to flatten it reduces the complexity of individual JSON documents, lowering memory consumption during the insert. Option E, batching the INSERT operations limits the amount of memory used in each individual operation, preventing the warehouse from being ovemhelmed. Option A, increasing the warehouse size can help, but it's often a more expensive solution than optimizing the data loading process itself. Option C only strips the outer array. Option D does not resolve the issue

No community discussion yet for this question.