Answer: Use of the insertFiles REST endpoint, Set the pipe parameter to auto-ingest

The question asks for two actions that trigger a Snowpipe data pipe to load files. Based on Snowflake documentation and the community discussion, option C (Use of the insertFiles REST endpoint) is correct because it manually triggers Snowpipe by notifying Snowflake of staged files to load. Option E (Set the pipe parameter to auto-ingest) is correct because it enables automated triggering via cloud storage event notifications (e.g., S3 ObjectCreated), which enqueues files automatically upon landing in the stage. Option A (INSERT statement) is incorrect as it loads data directly into tables, bypassing Snowpipe. Option B (COPY INTO [table]) is incorrect as it also loads data directly, not through Snowpipe. Option D (insertReport REST endpoint) is incorrect because it retrieves load history reports and does not trigger loading.

Author: LeetQuiz Editorial Team