COF-C03 Data Loading, Unloading, and Connectivity Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  PARSE_HEADER = TRUE

  Why it's wrong here

  PARSE_HEADER is not a valid FILE_FORMAT option in Snowflake. There is no such parameter. The correct parameter to skip header rows is SKIP_HEADER. PARSE_HEADER might be confused with other systems, but it is not recognized by Snowflake.

• ✓

  SKIP_HEADER = 1

  Why this is correct

  SKIP_HEADER specifies the number of header rows to skip at the beginning of each file. Setting it to 1 will skip the first row, which is the header. This is the correct option to ignore the header row. It is commonly used with CSV files that have a single header line.

• ✗

  FIELD_DELIMITER = ','

  Why it's wrong here

  FIELD_DELIMITER specifies the character that separates fields in the file. It does not control header skipping. While it is essential for parsing CSV files, it does not affect whether the header row is loaded or skipped. The default is comma, but it must be set correctly for the file format.

• ✗

  SKIP_BLANK_LINES = TRUE

  Why it's wrong here

  SKIP_BLANK_LINES controls whether blank lines in the file are skipped. It does not skip header rows. While it can be useful for files with empty lines, it does not address the header row. Setting it to TRUE would not skip the header, and the header would be loaded as data, potentially causing errors.