SnowPro Core Certification — Question 840

What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?

Answer options

• A. BINARY_FORMAT
• B. ESCAPE_UNENCLOSED_FIELD
• C. FIELD_OPTIONALLY_ENCLOSED_BY
• D. SKIP_BYTE_ORDER_MARK

Correct answer: C

Explanation

The correct answer is C, FIELD_OPTIONALLY_ENCLOSED_BY, which allows for the specification of quotes for enclosing fields in a CSV file. A, B, and D are not relevant to controlling how fields are enclosed in the CSV format.