SnowPro Core Certification — Question 824

When unloading the data for file format type specified (TYPE = 'CSV'), SQL NULL can be converted to string ‘null’ using which file format option?

Answer options

• A. SKIP_BYTE_ORDER_MARK
• B. EMPTY_FIELD_AS_NULL
• C. NULL_IF
• D. ESCAPE_UNENCLOSED_FIELD

Correct answer: C

Explanation

The correct answer is C, NULL_IF, as it specifically defines how SQL NULL values should be represented in the output file. The other options do not address the conversion of SQL NULL to a string; SKIP_BYTE_ORDER_MARK deals with BOMs, EMPTY_FIELD_AS_NULL handles empty fields, and ESCAPE_UNENCLOSED_FIELD relates to escaping characters in fields.