DEA-C02 Data Movement 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.

• ✗

  FIELD_OPTIONALLY_ENCLOSED_BY = '"'

  Why it's wrong here

  This option specifies that fields may be enclosed in double quotes, which is unrelated to skipping header rows. It is used to correctly parse fields that contain delimiters. It does not affect the header row; the header would still be loaded as data if not skipped.

• ✗

  SKIP_FILE = '1'

  Why it's wrong here

  SKIP_FILE is used to skip entire files based on a pattern or a number of errors. It does not skip rows within a file. Using SKIP_FILE = '1' would skip files that have one or more errors, not the header row. It is not appropriate for skipping a header row.

• ✓

  SKIP_HEADER = 1

  Why this is correct

  The SKIP_HEADER option 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 way to handle CSV files with a single header row, ensuring that column names are not loaded as data.

• ✗

  HEADER = TRUE

  Why it's wrong here

  There is no HEADER option in the COPY INTO command. While some tools use a HEADER parameter, Snowflake uses SKIP_HEADER to specify the number of header rows to skip. HEADER = TRUE would be invalid syntax and would cause an error.