Answer-first summary for fast verification
Answer: It removes object or array elements containing null values.
The STRIP_NULL_VALUES file format option specifically removes object or array elements containing null values when loading semi-structured data into Snowflake. This is clearly stated in the Snowflake documentation and confirmed by the community discussion where all comments (with upvotes) unanimously select option D. The other options are incorrect: A is wrong because it doesn't remove null values from all columns, B is incorrect as it doesn't convert nulls to empty strings, and C is wrong because it doesn't skip entire rows with null values - it only removes specific null-containing elements within semi-structured data objects or arrays.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the purpose of the STRIP_NULL_VALUES file format option when loading semi-structured data into Snowflake?
A
It removes null values from all columns in the data.
B
It converts null values to empty strings during loading.
C
It skips rows with null values during the loading process.
D
It removes object or array elements containing null values.