Does Snowflake support both row-level and column-level security policies?

• A. True
• B. False
• C. Only column-level security
• D. Not supported

Answer: (A)

Snowflake supports both row-level and column-level security policies. Row-level security uses Row Access Policies to filter which rows a user can see at query time, based on session context or user attributes. Column-level security uses Masking Policies to determine how data in a column is presented, again driven by the user’s role or session context. You can apply a Row Access Policy to a table and a Masking Policy to a column on the same table, allowing you to control visibility of entire rows and of individual column values simultaneously. This combination lets you enforce nuanced access rules, such as showing only relevant rows to a user while masking sensitive column data for others.