Snowflake
COF-R02 · Question #91
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
The correct answer is B. GRANT ROLE MYROLE TO USER USER1. See the full explanation below for the reasoning.
Question
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
Options
- AGRANT ROLE MYROLE TO USER USER1;
- BGRANT ROLE MYROLE TO USER USER1;
- CGRANT ROLE MYROLE TO USER USER1;
- DGRANT ROLE MYROLE TO USER USER1;
How the community answered
(33 responses)- A3% (1)
- B76% (25)
- C6% (2)
- D15% (5)
Community Discussion
No community discussion yet for this question.