When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Choose two.)
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Choose two.)
To differentiate between empty strings and NULL values when unloading data, the parameters FIELD_OPTIONALLY_ENCLOSED_BY and EMPTY_FIELD_AS_NULL should be used. FIELD_OPTIONALLY_ENCLOSED_BY specifies a character that encloses the field, allowing empty strings to be enclosed and thus distinguishable from NULL values. EMPTY_FIELD_AS_NULL determines how to handle empty fields; when set to TRUE, empty fields are treated as NULL values, further helping to differentiate between actual empty strings and NULLs in the unloaded data.
https://docs.snowflake.com/en/user-guide/data-unload-considerations
Correct Answers: C. FIELD_OPTIONALLY_ENCLOSED_BY and D. EMPTY_FIELD_AS_NULL FIELD_OPTIONALLY_ENCLOSED_BY: This parameter specifies a character that encloses the field. By using this parameter, you can ensure that empty strings are enclosed within the specified character (e.g., double quotes), allowing them to be differentiated from NULL values. EMPTY_FIELD_AS_NULL: This parameter determines how to handle empty fields during the unload operation. When set to TRUE, empty fields are treated as NULL values. This helps in distinguishing between actual empty strings and NULLs in the unloaded data.