SOL-C01 · Question #115
You are loading semi-structured JSON data into a Snowflake table named 'ORDERS'. The JSON files contain nested arrays and occasionally have missing fields. You need to load only the 'order id' and 'cu
The correct answer is C. Option C. The answer choices are missing their actual content - Options A through E are listed only as placeholders ("Option A", "Option B", etc.) without the SQL statements or descriptions needed to evaluate them. Could you paste the full text of each option? Once you share the actual COP
Question
You are loading semi-structured JSON data into a Snowflake table named 'ORDERS'. The JSON files contain nested arrays and occasionally have missing fields. You need to load only the 'order id' and 'customer id' fields. The 'customer id' field is sometimes nested within a 'customer' object, while the 'order id' is always at the top level. Which 'COPY INTO' command is the MOST efficient and resilient way to achieve this, accounting for potential data variations?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
How the community answered
(51 responses)- A10% (5)
- B20% (10)
- C65% (33)
- D2% (1)
- E4% (2)
Explanation
The answer choices are missing their actual content - Options A through E are listed only as placeholders ("Option A", "Option B", etc.) without the SQL statements or descriptions needed to evaluate them.
Could you paste the full text of each option? Once you share the actual COPY INTO statements or descriptions for A–E, I can explain exactly why C is correct and why the others fall short.
Topics
Community Discussion
No community discussion yet for this question.