nerdexam
Snowflake

COF-C02 · Question #382

What are the least privileges needed to view and modify resource monitors? (Select TWO).

The correct answer is C. MONITOR D. MODIFY. Resource monitors in Snowflake control credit usage for virtual warehouses and accounts. To view a resource monitor, a user needs the MONITOR privilege on it. To modify a resource monitor (e.g., change its credit quota or thresholds), the user needs the MODIFY privilege. These…

Account Access and Security

Question

What are the least privileges needed to view and modify resource monitors? (Select TWO).

Options

  • ASELECT
  • BOWNERSHIP
  • CMONITOR
  • DMODIFY
  • EUSAGE

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    94% (34)

Explanation

Resource monitors in Snowflake control credit usage for virtual warehouses and accounts. To view a resource monitor, a user needs the MONITOR privilege on it. To modify a resource monitor (e.g., change its credit quota or thresholds), the user needs the MODIFY privilege. These are the two least-privilege grants required for those respective operations. SELECT (A) is a data access privilege unrelated to resource monitors. OWNERSHIP (B) grants full control but is far more than the minimum needed. USAGE (E) is typically applied to warehouses, databases, schemas, and integrations-not resource monitors.

Topics

#Resource Monitors#Privileges#Access Control

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice