Answer: Cloud messaging, REST endpoints

The question asks for two methods to trigger Snowpipe to load data from staged files. According to Snowflake documentation and the community discussion (with 100% consensus and upvoted comments referencing official docs), the correct mechanisms are: A) Cloud messaging and D) REST endpoints. Cloud messaging involves using services like AWS SQS or Azure Event Grid to notify Snowpipe of new files, while REST endpoints allow programmatic calls to trigger loading. Options B (Email integrations), C (Error notifications), and E (Snowsight interactions) are not valid methods for triggering Snowpipe loads, as they are either unrelated or not supported mechanisms for this purpose.

Author: LeetQuiz Editorial Team