
Explanation:
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.
Ultimate access to all questions.
No comments yet.