nerdexam
Snowflake

COF-R02 · Question #314

What privilege should a user be granted to change permissions for new objects in a managed access schema?

The correct answer is C. Grant the MANAGE GRANTS global privilege. See the full explanation below for the reasoning.

Question

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Options

  • AGrant the OWNERSHIP privilege on the schema.
  • BGrant the OWNERSHIP privilege on the database.
  • CGrant the MANAGE GRANTS global privilege.
  • DGrant ALL privileges on the schema.

How the community answered

(44 responses)
  • A
    5% (2)
  • B
    2% (1)
  • C
    82% (36)
  • D
    11% (5)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice