SnowPro Advanced: Architect · Free practice question 5 of 10
Cost controls
An Architect needs a hard cap so that a specific virtual warehouse cannot consume more than 500 credits per month, and any queries that would push it past that threshold are stopped. Which Snowflake feature implements this?
- A.A resource monitor with credit_quota=500 and a SUSPEND_IMMEDIATE action at 100%.
- B.A statement timeout setting on the warehouse.
- C.A row access policy on the tables the warehouse queries.
- D.Setting the warehouse's AUTO_SUSPEND to a lower value.
Show answer and explanation
Correct answer: A. A resource monitor with credit_quota=500 and a SUSPEND_IMMEDIATE action at 100%.
Why: Resource monitors enforce credit quotas and can perform actions at percentage thresholds — SUSPEND_IMMEDIATE at 100% stops the warehouse mid-query when the cap is hit. Statement timeout limits per-query time, not credits. Row access policies control data visibility. Auto-suspend controls idle behavior.