SOL-C01 · Question #123
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
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #123. The question stem and answer options stay visible for context.
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.
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.