exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 197 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 197
Topic #: 1
[All SnowPro Core Questions]

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 Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
JUHYEON
Highly Voted 2 years, 1 month ago
Selected Answer: D
i think D
upvoted 5 times
...
37ceea2
Most Recent 2 days, 1 hour 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
...
Mallikharjuna452
7 months ago
D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.
upvoted 1 times
...
_yyukta
12 months ago
Selected Answer: D
D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.
upvoted 1 times
...
MultiCloudIronMan
1 year, 7 months ago
Selected Answer: D
Correct
upvoted 1 times
...
harshkoshta
1 year, 7 months ago
A can also right, because we can schedule task
upvoted 1 times
...
c0d3g
1 year, 11 months ago
Selected Answer: D
D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago