Câu 15: DEA-C02: SnowPro Advanced Data Engineer DEA-C02

A user ran a one-time AI_SUMMARIZE_AGG query on a large log table using a Cortex Al model. The query consumed more than 1,000 credits, even though it ran on a size Small virtual warehouse. A Data Engineer has been asked to implement a Snowflake-native, automated alert that triggers whenever a single Cortex AI SQL query consumes 300 credits, so that the query text and model choice can be reviewed. How should these requirements be met?

1. A. Create a scheduled task that queries SNOWFLAKE.ACCOUNT_USAGE.CORTEX_AISQL_USAGE_HISTORY for recent rows where CREDITS_USED > 300. Join those rows toSNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY to capture the SQL text, and use a notification integration in the task body to send an alert with the query and model details. — đáp án hiện tại
2. B. Attach a resource monitor with a 300-credit limit to the virtual warehouse used to run the Cortex AI SQL. Configure the monitor to send a notification when the limit is reached, and use the resource monitor alerts to identify any Cortex query that exceeds 300 credits.
3. C. Create a scheduled task that checks SNOWFLAKE.ACCOUNT_USAGE.METERING_DAILY_HISTORY for SERVICE_TYPE = 'AI_SERVICES ' and TOTAL_CREDITS > 300 on the current date, and send a notification whenever the daily AI_SERVICES usage exceeds the threshold so the team can review the queries that ran that day.
4. D. Set a low STATEMENT_TIMEOUT_IN_SECONDS value for sessions that use Cortex AI SQL, based on how long a typical query would take to reach 300 credits, and use the statement timeout threshold to prevent any single Cortex query from exceeding the 300-credit threshold.