SnowPro Core Certification — Question 1025

What is the purpose of the STRIP_NULL_VALUES file format option when loading semi-structured data files into Snowflake?

Answer options

• 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.

Correct answer: D

Explanation

The STRIP_NULL_VALUES option is specifically designed to remove object or array elements that contain null values, which is essential for maintaining data integrity during the loading process. Options A, B, and C misrepresent the functionality since they suggest either removing all nulls, converting them, or skipping entire rows, which is not the intent of this specific option.