Which option sets the delimiter in a file format?

• A. DELIMITER
• B. FIELD_DELIMITER
• C. SEPARATOR
• D. FIELD_SEPARATOR

Answer: (B)

Understanding how we tell a file how to break apart each line is key. The delimiter is the character that separates fields within a row, such as a comma in a CSV or a tab in a TSV. When configuring a file format, the option named FIELD_DELIMITER explicitly defines that field-level separator, making it the clear and precise choice for parsing the columns correctly. Using this specific name communicates exactly which part of the data is being split, which is essential for accurate loading and interpretation.

Other names like DELIMITER, SEPARATOR, or FIELD_SEPARATOR are more ambiguous or not the standard parameter in many tools. DELIMITER is generic and could refer to rows or other separators; SEPARATOR is similarly unclear; FIELD_SEPARATOR is close in meaning but not the standard convention in this context, whereas FIELD_DELIMITER is the exact, unambiguous option used to specify the character that separates fields.