Answer: Use Snowpipe.

The question asks for the MOST efficient way to load streaming data into Snowflake. Snowpipe (option B) is specifically designed for continuous, automated loading of streaming data in near real-time, making it the most efficient choice. The community discussion strongly supports this, with 86% selecting B and comments emphasizing that Snowpipe is for streaming while COPY command is for batch loading. Option A (COPY command) is for batch operations, not streaming. Option C (Load Data Wizard) is a UI tool for manual loading, not optimized for streaming. Option D (tasks and streams) refers to Change Data Capture (CDC) for tracking changes in existing tables, not for initial streaming data ingestion.

Author: LeetQuiz Editorial Team