SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 35


True or False: It is possible to load data into Snowflake without creating a named File Format object.

Show Answer
Correct Answer: A

It is possible to load data into Snowflake without creating a named File Format object because Snowflake provides built-in file formats that can be used directly. For example, using the COPY INTO command, one can specify the built-in CSV file format without needing to create a named file format object explicitly.

Discussion

12 comments
Sign in to comment
SD3Option: A
May 31, 2022

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?

arpit_dataguyOption: A
Jan 28, 2022

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.

GraghuOption: A
May 9, 2022

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

Tapasgup007Option: A
Dec 6, 2022

A is correct

yayaroOption: B
Apr 9, 2022

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

abbciaOption: A
Mar 12, 2023

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

Raju039Option: A
Mar 1, 2023

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

SteveCrownOption: A
Apr 22, 2023

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...

Mayuri917233Option: A
May 11, 2023

A is correct

ColourseunOption: A
Nov 3, 2023

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.

_yyuktaOption: A
Feb 23, 2024

A. True

Mallikharjuna452Option: A
Jul 18, 2024

Yes It is possible,A.True