Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 3

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

    Correct Answer: C

    APPLY MASKING POLICY, APPLY ROW ACCESS POLICY, and APPLY SESSION POLICY privileges are granted at the schema level. These policies affect data security and access control within a specific schema, making the schema the appropriate level for these privileges.

Discussion
serg_kharOption: A

my choice is A: https://docs.snowflake.com/en/user-guide/security-access-control-privileges#global-privileges

JRayanOption: C

Global is privilege not object. Hence, C. Schema(object) is the right option.

Corleone433

Agree, the way question is composed, I would say C.

qqcvdOption: A

These are global privileges to grant, see : https://docs.snowflake.com/en/sql-reference/sql/grant-privilege

GwoOption: A

A is correct. Global object level. https://docs.snowflake.com/en/user-guide/security-access-control-privileges

NachoPrendesOption: A

https://docs.snowflake.com/en/user-guide/security-access-control-privileges

BDalyOption: D

Table is correct, the listed privileges AAPLY to tables and views. While it is a global permission, the OBJECT they are applied to are tables/views. Hence D

ArumughamOption: A

Answer is A

hillcat111

Answer is A and is validated

omsinghOption: C

schema is correct answer

omsingh

it should be A, global

henrik0

seems as both global and schema are valid options