COF-C03 Question 193
Single answerNotificationsA data engineering team wants Snowflake to send a message to an external cloud messaging service whenever a task detects late-arriving files in a staging area. The team also wants to avoid embedding cloud credentials directly in SQL objects. Which Snowflake feature should the architect configure to enable this integration?
- A
A notification integration that is referenced by the SQL logic that sends the notification
- B
An external function that directly calls the cloud messaging endpoint without any additional Snowflake object
- C
A security integration that stores the cloud messaging credentials and is invoked by the task
- D
A network rule that allows outbound access from the warehouse to the cloud messaging service
Show answer and explanation
Correct answer: A
Explanation
The correct answer is a notification integration. In Snowflake, notification integrations are the supported mechanism for integrating Snowflake with external messaging services used for notifications. This design supports the requirement to avoid hardcoding credentials in SQL logic. In practical implementations, tasks or procedures can use Snowflake functionality that references the notification integration when an event condition is met, such as detecting late-arriving files. By contrast, external functions and security integrations serve different purposes, and network rules are not the primary object for built-in notification delivery. This aligns with Snowflake documentation on notification integrations and best practices for managing external service connectivity through named integration objects rather than embedding secrets directly in code.
- A. Correct.
Correct. Snowflake uses a notification integration to enable notifications with supported cloud messaging services. This object stores the configuration needed for Snowflake to communicate with the external notification service, allowing SQL-based logic such as notification-related system functions to reference the integration without embedding cloud credentials directly in application code or SQL objects.
- B. Incorrect.
Incorrect. External functions are used to call externally hosted services, typically through API integration, but they are not the standard Snowflake mechanism for publishing notifications to supported cloud messaging services. This option reflects a common misconception that any outbound communication from Snowflake should use external functions.
- C. Incorrect.
Incorrect. A security integration is used for authentication-related integrations such as federated identity, OAuth, and some external access scenarios, but it is not the object used to configure Snowflake notifications to cloud messaging services. Someone might pick this because of the credential-management wording, but notifications use notification integrations instead.
- D. Incorrect.
Incorrect. Network rules are related to controlling network access patterns for features such as external network access, not for configuring Snowflake's built-in notifications capability. Warehouses also do not directly manage this type of outbound notification connectivity through a network rule in the way described here.