SnowPro Core Certification — Question 1071

When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Choose two.)

Answer options

• A. ESCAPE_UNENCLOSED_FIELD
• B. REPLACE_INVALID_CHARACTERS
• C. FIELD_OPTIONALLY_ENCLOSED_BY
• D. EMPTY_FIELD_AS_NULL
• E. SKIP_BLANK_LINES

Correct answer: C, D

Explanation

The correct options, C (FIELD_OPTIONALLY_ENCLOSED_BY) and D (EMPTY_FIELD_AS_NULL), are necessary to identify and handle empty strings and NULL values accurately. The other options do not specifically address the differentiation between these two states, making them unsuitable for this purpose.