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;
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
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund