Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 77

Which of the following are valid approaches to loading data into a Snowflake table? (Choose all that apply.)

    Correct Answer: A, B, D

    There are several valid approaches to loading data into a Snowflake table. These include bulk copy from an External Stage, continuous load using the Snowpipe REST API, and bulk copy from an Internal Stage. The Snowflake Web Interface (UI) data loading wizard is another method, but it’s typically used for small amounts of data and not considered a comprehensive approach for larger or more frequent data loads. Therefore, the valid approaches are bulk copy from an External Stage, continuous load using Snowpipe REST API, and bulk copy from an Internal Stage.

Discussion
redsky0

All are correct.

baig123Options: ABC

ABCD are correct, data can be loaded into snowflake table from internal stage using bulk copying.

BigDataBB

All are valid but the question said "valid approaches" so as approach and not as spot operation, i think that the "The Snowflake Web Interface (UI) data loading wizard" is not a valid approach. Do you agree with me?

Hopefan

well its hard to say its not valid but logically better not to use it this way ?

RooheeOptions: ABC

bulk loading from internal stage is also possible. A B C D all are correct and supprted by snowflake https://docs.snowflake.com/en/user-guide/data-load-local-file-system

lofibeatsOptions: ABD

correct

isolated_sniperOptions: ABC

ABCD. All options are correct. The Snowflake Web Interface (UI) data loading wizard is allowed for small amounts of data

c0d3gOptions: BCD

Why can't I select all the options? ABCD are corrrect.

BigDataBBOptions: ABD

All are valid, but the question said "valid approaches" so as approach and not as spot operation, i think that the "The Snowflake Web Interface (UI) data loading wizard" is not a valid approach.

Tapasgup007Options: ABC

ABCD all are correct

kapilnilesh

ABCD are correct

Mallikharjuna452Options: ABC

All options

pranalig

correct answer:ABCD

PrashantGupta1616Options: ABD

The valid approaches to loading data into a Snowflake table are: A. Bulk copy from an External Stage B. Continuous load using Snowpipe REST API D. Bulk copy from an Internal Stage Therefore, the correct options are: A. Bulk copy from an External Stage B. Continuous load using Snowpipe REST API D. Bulk copy from an Internal Stage

BobFar

ABCD is correct!

MultiCloudIronManOptions: ABC

ABCD Correct

Mayuri917233Options: ABC

ABC are correct

abdel88Options: ABC

All are correct.

KarBiswaOptions: ABC

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