Exam SnowPro Core topic 1 question 1015 discussion

B: The number of columns in each row should be consistent.

The number of columns in each row should be consistent.

B is correct https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare#preparing-delimited-text-files

B is correct. Any valid character can be used as a field delimiter (not A) Snowflake recommends that files be compressed, but it's not required (Not C) You can drop columns from the file to the target table (Not D) https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare#preparing-delimited-text-files

C A is not right https://docs.snowflake.com/en/user-guide/data-load-prepare Structured Delimited (CSV, TSV, etc.) Any valid singlebyte delimiter is supported; default is comma (i.e. CSV). We recommend that you compress your data files when you are loading large data set. re: delimiter, you can set up your own delimiter for CSV using CREATE FILE FORMAT: https://docs.snowflake.com/en/sql-reference/sql/create-file-format

https://docs.snowflake.com/en/user-guide/data-load-transform

Default delimiter for CSV is comma as per SF docmn. Otherwise we have to create the format.

A is the correct answer.