SnowPro Core Certification — Question 1165

What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the COPY INTO [location] command used during data unloading? (Choose two.)

Answer options

• A. Single quote character (')
• B. NULL
• C. 'NULL'
• D. NONE
• E. 'NONE'

Correct answer: A, D

Explanation

The correct answers are A and D because the FIELD_OPTIONALLY_ENCLOSED_BY option can be set to a single quote character (') or NONE, indicating that no enclosing character is used. Options B, C, and E are incorrect because NULL, 'NULL', and 'NONE' do not fit the expected valid values for this option.