SnowPro Core Certification — Question 201

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?

Answer options

• 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 MARKET;

Correct answer: B

Explanation

The correct answer is B, as it grants the necessary modify permissions to the marketing role, allowing team members to change the warehouse size. Option A does not grant the right permissions to the appropriate role, while options C and D do not provide the necessary role-level access for the entire marketing team to make changes.