Question 390
A vendor file uses pipe delimiters and embedded quoted text. Which base format should have those delimiters configured?
Explanation
Correct Answer
Correct: CSV-style delimited text. CSV file format parses delimited text using configured field, quote and header options.
Incorrect Answers
Incorrect in this scenario: JSON file format parses JSON documents and JSON line records; it does not provide CSV-style delimited text.
Incorrect in this scenario: PARQUET file format reads supported columnar Parquet-encoded files; it does not provide CSV-style delimited text.
Incorrect in this scenario: XML file format interprets supported XML content for loading; it does not provide CSV-style delimited text.