Snowpipe is designed to load new data typically within a minute after a file notification is sent.

• A. Immediately
• B. Within a minute
• C. Within an hour
• D. Within a day

Answer: (B)

Snowpipe is built for near real-time data ingestion. When a file arrives in a stage and a notification triggers the load, Snowpipe starts the process automatically and aims to have the data available in your target table within about a minute. This short latency is what makes Snowpipe suitable for streaming-like ingestion and quick data availability. The actual time can vary a bit depending on file size, concurrency, and system load, but the goal is continuous, timely loading rather than long delays. That’s why the best choice reflects a near-immediate turnaround—within a minute. Loading immediately isn’t guaranteed because there’s always a small processing overhead to detect the event and start the load, and waiting hours or days would be far outside Snowpipe’s purpose.