Snowflake
COF-R02 · Question #108
COF-R02 Question #108: Real Exam Question with Answer & Explanation
The correct answer is D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Question
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?
Options
- ACreate a task that runs a copy into operation from an external stage every 5 minutes
- BCreate a task that puts the files in an internal stage and automate the data loading wizard
- CCreate a task that runs a GET operation to intermittently check for new files
- DSet up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Community Discussion
No community discussion yet for this question.