COF-C02 Question #591: Real Exam Question with Answer & Explanation

The correct answer is A: MODIFY, MONITOR and OPERATE privileges. Granting a user the MODIFY, MONITOR, and OPERATE privileges on all virtual warehouses in Snowflake is equivalent to granting the global MANAGE WAREHOUSES privilege. These privileges collectively provide comprehensive control over virtual warehouses. MODIFY Privilege: Allows users

Account Access and Security

Question

Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?

Options

AMODIFY, MONITOR and OPERATE privileges
Bownership and usage privileges
CAPPLYBUDGET and audit privileges
DMANAGE LISTING ADTOTOLFillment and resolve all privileges

Explanation

Granting a user the MODIFY, MONITOR, and OPERATE privileges on all virtual warehouses in Snowflake is equivalent to granting the global MANAGE WAREHOUSES privilege. These privileges collectively provide comprehensive control over virtual warehouses. MODIFY Privilege: Allows users to change the configuration of the virtual warehouse. Includes resizing, suspending, and resuming the warehouse. MONITOR Privilege: Allows users to view the status and usage metrics of the virtual warehouse. Enables monitoring of performance and workload. OPERATE Privilege: Grants the ability to start and stop the virtual warehouse. Includes pausing and resuming operations as needed.

Topics

#Snowflake Privileges#Virtual Warehouses#Role-Based Access Control (RBAC)#Global Privileges

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions