SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 77


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

Show Answer
Correct Answer: ABD

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

17 comments
Sign in to comment
redsky0
Jan 4, 2022

All are correct.

baig123Options: ABC
Dec 16, 2022

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

BigDataBB
Jan 9, 2023

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
May 12, 2023

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

RooheeOptions: ABC
Sep 13, 2023

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

kapilnilesh
Dec 7, 2022

ABCD are correct

Tapasgup007Options: ABC
Dec 8, 2022

ABCD all are correct

BigDataBBOptions: ABD
Jan 9, 2023

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.

c0d3gOptions: BCD
Mar 5, 2023

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

isolated_sniperOptions: ABC
Apr 28, 2023

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

lofibeatsOptions: ABD
Aug 25, 2023

correct

KarBiswaOptions: ABC
Feb 8, 2023

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

abdel88Options: ABC
May 3, 2023

All are correct.

Mayuri917233Options: ABC
May 11, 2023

ABC are correct

MultiCloudIronManOptions: ABC
Jul 15, 2023

ABCD Correct

BobFar
Oct 12, 2023

ABCD is correct!

PrashantGupta1616Options: ABD
Jun 6, 2024

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

pranalig
Jun 16, 2024

correct answer:ABCD

Mallikharjuna452Options: ABC
Jul 18, 2024

All options