Exam SnowPro Core topic 1 question 35 discussion

Yes It is possible,A.True

A. True

A: True is correct Snowflake loads data as CSV by default, but if the file is not CSV, you will have to specify the File Format.

A is correct

True. Snowflake supports loading data without creating a named File Format object. Snowflake provides built-in file formats that can be used to load data without the need to create a file format object explicitly. For example, to load a CSV file, you can use the built-in CSV file format by simply specifying the FILE_FORMAT option as CSV in the COPY INTO command. This allows you to quickly load data without the overhead of creating a named file format object. Send a message...

a is true, you can specify a format but you don't have to

https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format

A is correct

As the link suggests: 'In regular use, this step is optional, but is recommended'. Therefore it can be loaded without. I think thats enough proof?

table will be loaded with CSV format as default format if there is no file format defined

Needs a proof that shows A is correct. Until then I will go with B.

A is the correct answer. With a table created we can upload data from a csv file via web UI directly in the table without defining the FILE FORMAT.