COF-C03 Data Loading, Unloading, and Connectivity Practice Question
A data engineer is configuring a Snowpipe to automatically ingest files as they arrive in an external stage. They need to set up event notifications from the cloud provider to Snowflake. Which two components are required to enable this automated ingestion? (Choose two.)
⚠ Common exam trap
The trap here is overlooking the need for a notification integration and assuming that a storage integration alone suffices for event-driven ingestion.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
A storage integration object in Snowflake
To enable automated Snowpipe ingestion from an external stage, two key Snowflake objects are required: a storage integration to securely access the external stage, and a notification integration to receive event notifications from the cloud provider. The storage integration provides the necessary permissions, while the notification integration allows Snowpipe to be triggered by events. Other components like file formats or tasks are not required for the event notification setup.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A named file format object
Why it's wrong here
A named file format defines how data in files should be parsed, such as delimiters and data types. While it is often used with COPY INTO and Snowpipe, it is not strictly required for setting up event notifications. The pipe can use an inline file format or a named one. Therefore, it is not a required component for enabling automated ingestion via event notifications.
- ✗
A task to periodically check for new files
Why it's wrong here
A task is a scheduled job within Snowflake, but Snowpipe is designed for event-driven ingestion, not polling. Using a task to periodically check for new files would be a manual polling approach and is not the automated event notification method. Snowpipe relies on cloud events, not scheduled tasks, so this option is not required and is incorrect for the scenario.
- ✓
A storage integration object in Snowflake
Why this is correct
A storage integration is a Snowflake object that stores the identity and access management (IAM) credentials for the external cloud storage. It allows Snowflake to securely access the external stage without embedding credentials in the stage definition. For automated Snowpipe ingestion, a storage integration is required to grant Snowflake the necessary permissions to read from the stage. This is a fundamental component.
- ✓
A notification integration object in Snowflake
Why this is correct
A notification integration is a Snowflake object that enables Snowflake to receive event notifications from cloud providers such as Amazon S3, Google Cloud Storage, or Microsoft Azure. It is required to configure the pipe to automatically trigger when new files arrive. Without a notification integration, Snowpipe cannot receive the event notifications and thus cannot automate ingestion.
- ✗
An external function to process the notifications
Why it's wrong here
External functions are used to call code outside Snowflake, such as AWS Lambda. They are not used for receiving event notifications for Snowpipe. Instead, Snowpipe uses notification integrations to receive events directly from the cloud provider's event messaging service. An external function is not part of the standard Snowpipe automation setup and is therefore incorrect.
About these practice questions
One of 280 original COF-C03 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This COF-C03 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the COF-C03 exam.