ExamGecko
Question list
Search
Search

Question 72 - COF-C02 discussion

Report
Export

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;
Answers
A.
ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
B.
GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Answers
B.
GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
C.
GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
Answers
C.
GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
D.
GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Answers
D.
GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
Suggested answer: B

Explanation:

:The correct statement to accommodate the request for a marketing co-worker to change the size of their medium virtual warehouse calledmktg__WHis to grant theMODIFYprivilege on the warehouse to theROLE MARKETING. This privilege allows the role to change the warehouse size among other properties.

References:

[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Access Control Privileges1

asked 23/09/2024
Adish Narayan
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first