nerdexam
Snowflake

COF-R02 · Question #134

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?

The correct answer is B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING. See the full explanation below for the reasoning.

Question

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?

Options

  • AALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
  • BGRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
  • CGRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
  • DGRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

How the community answered

(56 responses)
  • A
    4% (2)
  • B
    79% (44)
  • C
    5% (3)
  • D
    13% (7)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice