SnowPro Core Certification — Question 414

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?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because using Snowpipe with auto-ingest allows for real-time data loading into Snowflake as files are added to the cloud storage location. Options A, B, and C involve manual or periodic methods that are less efficient compared to the automatic ingestion provided by Snowpipe, which minimizes latency and ensures timely data availability.