Exam SnowPro Core topic 1 question 197 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 197
Topic #: 1

A user has an application that writes a new file to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

A. Create a task that runs a COPY INTO operation from an external stage every 5 minutes.
B. Create a task that PUTS the files in an internal stage and automate the data loading wizard.
C. Create a task that runs a GET operation to intermittently check for new files.
D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.

Show Suggested Answer

Suggested Answer: D 🗳️

by JUHYEON at Jan. 2, 2023, 5:12 a.m.

Comments

Submit Cancel

JUHYEON

Highly Voted 2 years, 7 months ago

Selected Answer: D

i think D

upvoted 5 times

...

37ceea2

Most Recent 6 months ago

Selected Answer: A

D is not a good answer. When we have cloud provider notification, the AUTO-INGEST for SNOWPIPE has to be FALSE. A is good, due to the fact that it refers to External Stage and, in the "SNOWFLAKE language" when it is about Cloud Storage it is about files on External Stages. Hence, we have to load from External Stages to Table, using COPY INTO. Last idea, is what does the question understand by "with AUTO-INGEST"? AUTO-INGEST=TRUE or AUTO-INGEST=FALSE. I still remain to A.

upvoted 1 times

...