
Explanation:
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.
Which two actions will cause a data pipe to load files?
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
No comments yet.