SnowPro Core Certification — Question 1270

Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

Answer options

• A. Alerts
• B. External tables
• C. Secure views
• D. Materialized views

Correct answer: A

Explanation

The correct answer is A, Alerts, as they are specifically designed to trigger actions based on defined conditions and can operate on a schedule. The other options, such as External tables, Secure views, and Materialized views, do not provide functionality for periodic actions; instead, they serve different purposes related to data storage and access.