Answer-first summary for fast verification
Answer: GRANT MODIFY ON WAREHOUSE MKTG_WH TO ROLE MARKETING;
The correct answer is B because in Snowflake, privileges should be granted to roles rather than directly to users, following the principle of role-based access control. The MODIFY privilege on a warehouse specifically allows changing warehouse properties including size, which matches the requirement. Option A uses incorrect syntax (ALLOW RESIZE) and grants directly to a user. Option C grants MODIFY directly to a user instead of a role. Option D grants OPERATE privilege which only allows starting/stopping the warehouse but not modifying its size. The community discussion shows strong consensus for B with 100% agreement and references to Snowflake documentation confirming that MODIFY privilege enables altering warehouse properties.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following statements will allow a marketing co-worker to change the size of their existing medium virtual warehouse named MKTG_WH?
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;
No comments yet.