Answer-first summary for fast verification
Answer: Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.
The question asks for the MOST efficient method to load files that are written every 5 minutes. Option D (Snowpipe with auto-ingest) is optimal because it provides near real-time ingestion by leveraging cloud provider notifications, automatically triggering data loading as soon as files arrive without manual intervention or polling. This eliminates the latency and resource overhead of scheduled tasks. While option A (COPY INTO every 5 minutes) could work, it is less efficient due to potential delays (files may be missed if written just after a run) and unnecessary compute usage when no files are present. Option B is inefficient as PUT operations and the data loading wizard are manual processes. Option C (GET operation) is incorrect as GET is for downloading files from Snowflake, not loading data. The community discussion shows strong consensus for D (90% selection, multiple upvoted comments), with one dissenting opinion about auto-ingest configuration, but Snowpipe auto-ingest is designed specifically for this efficient, event-driven ingestion scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user has an application that writes a new file to cloud storage every five minutes. What is the most efficient method to load these 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.
No comments yet.