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 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?
To allow a user to change the size of a warehouse in Snowflake, the MODIFY privilege must be granted. The correct statement to achieve this is 'GRANT MODIFY ON WAREHOUSE MKTG_WH TO ROLE MARKETING;' as it grants the necessary permissions to the role associated with the user.
https://docs.snowflake.com/en/sql-reference/sql/grant-privilege.html
Selected Answer: B
B is correct answer
Answer is B https://docs.snowflake.com/en/user-guide/security-access-control-privileges MODIFY Enables altering any properties of a warehouse, including changing its size. Required to assign a warehouse to a resource monitor. Note that only the ACCOUNTADMIN role can assign warehouses to resource monitors. OPERATE Enables changing the state of a warehouse (stop, start, suspend, resume). In addition, enables viewing current and past queries executed on a warehouse and aborting any executing queries.
B is correct
correct