SnowPro Advanced Architect

Files land every 10 seconds and must be visible almost immediately with minimal coding. A task has a minimum schedule interval of 60 seconds, so any COPY-plus-task or task-plus-stream approach (B, E) cannot meet the 10-second latency. Snowpipe with auto-ingest (A) uses cloud event notifications to load files continuously as they arrive with essentially no custom code, and a materialized view on an external table (C) exposes the staged data to dashboards and auto-refreshes as new files appear — both low-code, near-real-time. A one-off COPY INTO (D) is manual and not continuous. Therefore A and C.