Q: 13
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
Options
Discussion
I don't think it's B. D matches how Snowflake does privilege management, since you grant the ability to create objects at the schema level to a role, not directly to a user. Official docs and practice exams both push that roles-first approach, so seems right here. Agree?
Makes sense to choose D, that's how Snowflake expects permissions to be handled, through roles not users. No explanation needed!
D imo, since Snowflake grants schema privileges via roles not directly to users. B is a trap because you can't grant CREATE MATERIALIZED VIEW straight to a user. Pretty sure that's how the exam expects you to read it.
I don’t think it’s C, I’d pick B since granting privileges to the user directly seems fine if MYROLE isn’t needed for some reason. But does the question want the most secure method or specifically role-based access? If it asked for direct access, C or B could work.
Be respectful. No spam.
