Which of the following statements will accommodate this request?

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?
A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
B . GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
C . GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
D . GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

View Answer

Answer: B

Explanation:

The correct statement to accommodate the request for a marketing co-worker to change the size of their medium virtual warehouse called mktg__WH is to grant the MODIFY privilege on the warehouse to the ROLE MARKETING. This privilege allows the role to change the warehouse size among other properties.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Access Control Privileges1