Snowpro Advanced Architect · Free Practice Question Easy
Question 43
What is the purpose of the STRIP_NULL_VALUES file format option when loading JSON data into Snowflake?
- A Converts "null" strings into SQL NULL values.
- B Removes JSON elements containing the string "null" to save storage.
- C Retains "null" values in their original form for completeness.
- D Maps missing JSON elements to default column values.
Reveal correct answer
Correct answer: B
Explanation
STRIP_NULL_VALUES removes unnecessary "null" elements in JSON to optimize storage and performance.A. It removes null elements but does not convert them to SQL NULLs.
B. STRIP_NULL_VALUES prevents unnecessary storage and improves query performance.
C. Retaining "null" values can waste storage and slow queries.
D. STRIP_NULL_VALUES does not map missing elements.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
