Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 197

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?

Create a task that runs a COPY INTO operation from an external stage every 5 minutes.

Create a task that PUTS the files in an internal stage and automate the data loading wizard.

Create a task that runs a GET operation to intermittently check for new files.

Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.

Correct Answer: D

The most efficient way to get the files into Snowflake is to set up cloud provider notifications on the file location and use Snowpipe with auto-ingest. This approach allows for automated, real-time data ingestion as soon as new files appear in the cloud storage, eliminating the need for manual scheduling or frequent checking for new files. Snowpipe is designed specifically for continuous data ingestion and is optimized for this purpose.

Discussion

JUHYEONOption: D

i think D

c0d3gOption: D

D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.

Mallikharjuna452Option: D

D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.

_yyuktaOption: D

D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.

MultiCloudIronManOption: D

Correct

harshkoshtaOption: A

A can also right, because we can schedule task