A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?

The correct answer is B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING. The MODIFY privilege on a warehouse grants the ability to change warehouse properties, including resizing it (changing the warehouse size). Privileges in Snowflake should always be granted to roles, not directly to users, which is why option B (granting to a ROLE) is correct…

Account Access and Security

Question

Options

AALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
BGRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
CGRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
DGRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

How the community answered

(51 responses)

A
10% (5)
B
82% (42)
C
2% (1)
D
6% (3)

Explanation

The MODIFY privilege on a warehouse grants the ability to change warehouse properties, including resizing it (changing the warehouse size). Privileges in Snowflake should always be granted to roles, not directly to users, which is why option B (granting to a ROLE) is correct and option C (granting to a USER) is not best practice and is incorrect. Option D uses the OPERATE privilege, which only allows starting, stopping, suspending, and resuming a warehouse - it does not grant the ability to resize it. Option A uses invalid SQL syntax that does not exist in Snowflake.

Topics

#Snowflake Access Control#Virtual Warehouses#GRANT Statement#MODIFY Privilege

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice