SnowPro Core Certification — Question 587

What is the MOST efficient way to load streaming data into Snowflake?

Answer options

• A. Use the COPY command.
• B. Use Snowpipe.
• C. Use the Load Data Wizard.
• D. Use tasks and streams.

Correct answer: B

Explanation

Snowpipe is designed for continuous data loading and efficiently handles streaming data by automatically ingesting it as soon as it arrives in a specified location. The COPY command, while powerful for bulk loading, is not optimized for real-time ingestion like Snowpipe. The Load Data Wizard is a graphical tool that may not be suitable for streaming data, and tasks and streams are more about managing data flows rather than loading data efficiently.