SnowPro Core Certification — Question 1088

In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Choose two.)

Answer options

• A. Implementation of column-level security will optimize query performance.
• B. Column-level security supports encryption of the entire database.
• C. Column-level security ensures that only the table owner can access the data.
• D. Column-level security limits access to specific columns within a table based on user privileges.
• E. Column-level security allows the application of a masking policy to a column within a table or view.

Correct answer: D, E

Explanation

The correct answers, D and E, highlight that column-level security effectively restricts user access to specific columns based on their privileges and allows for the application of masking policies to protect sensitive data. Options A, B, and C are incorrect as they do not accurately describe the purpose or functionality of column-level security in Snowflake.