Exam SnowPro Advanced Architect topic 1 question 145 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 145
Topic #: 1

[All SnowPro Advanced Architect Questions]

An Architect created a database using the role DB_OWNER and a schema with managed access within this database using the role SCHEMA_OWNER. The team created a table inside this schema using the role OBJECT_OWNER.

Which role will be required to grant privileges on the table to other roles?

A. DB_OWNER
B. OBJECT_OWNER
C. SECURITYADMIN
D. SYSADMIN

Show Suggested Answer

Suggested Answer: A 🗳️

by ArunH at Nov. 26, 2025, 8:16 p.m.

Comments

Submit Cancel

ArunH

22 hours, 33 minutes ago

Selected Answer: C

By default DB_OWNER doesnt own the schema as it is created by SCHEMA_OWNER. Since Schema_owner is not in the choice, the only other role which can grant object is the one which has MANAGE GRANTS. Securityadmin is the only one which has global manage grants on all objects . According to snowflake documentaiton "Only the schema owner (the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant privileges on objects in the schema, including future grants, centralizing privilege management."

upvoted 1 times

...