SnowPro Core Certification — Question 1150

What actions will trigger a data pipe to load? (Choose two.)

Answer options

• A. Use of an INSERT statement
• B. Use of a COPY INTO [table] statement
• C. Use of the insertFiles REST endpoint
• D. Use of the insertReport REST endpoint
• E. Set the pipe parameter to auto-ingest

Correct answer: C, E

Explanation

The correct answers, C and E, are appropriate because the insertFiles REST endpoint is specifically designed to trigger loading actions for a data pipe, and setting the pipe parameter to auto-ingest automates this process. The other options do not directly initiate a data pipe load; for instance, A and B are standard SQL operations that do not utilize the data pipe functionality.