What is the purpose of row-level security in Snowflake?

• A. It determines whether a given row in a table or view should be returned.
• B. It prevents rows from being inserted.
• C. It prevents rows from being updated or deleted.
• D. It encrypts data at row level

Answer: (A)

Row-level security controls which rows a user can see in a query. In Snowflake, you attach a row access policy to a table or view, and that policy contains a predicate that can reference the user or role context (for example, current_user() or current_role()). When a query runs, Snowflake evaluates this predicate for each row and returns only the rows that satisfy it. This means different users can see different data based on their context, without changing the underlying rows. It doesn’t prevent inserts, updates, or deletes—that’s about data modification permissions—nor does it encrypt data; encryption is a separate concern.